Return Value is text need value as Date

[jbakerstull]

Hi all, 

I using the following formula in a column to return max start date per client. The formula works as intended but value is text based, I need it to be date value. Any help would be apperiated.  

LatestEntryDate = CALCULATE (

    MAX ( Client[Start_Date] ),

    ALLEXCEPT ( Client, Client[Clients Personal ID] ))

[jbakerstull]

Thanks for the reply, following error message populated when I place in Datevalue

[tamerj1 · Accepted solution]

Hi @jbakerstull 

It depends. But try to wrap it with DATEVALUE function 

LatestEntryDate =
DATEVALUE (
CALCULATE (
MAX ( Client[Start_Date] ),
ALLEXCEPT ( Client, Client[Clients Personal ID] )
)
)

[jbakerstull]

The error is now gone. I tested the created column against the Client (tbl) start date using formula below. I believe the error has been fixed. I'm just trying to fiqure out how to test the fix. 

Formula tested was

Match Dates = if(Client[ClientlatestEntry]=Client[Start_Date],1,0)

[tamerj1]

@jbakerstull 

Please try

Match Dates =
IF ( [ClientlatestEntry] = MAX ( Client[Start_Date] ), 1, 0 )

[jbakerstull]

Added Datevalue populated the folling error message:

Too many arguments were passed to the DATEVALUE function. The maximum argument count for the function is 1.