Finding the max date that is a string

[fitch1892]

Im trying to find the max date of each record. Ive tried using the summarize tool, but its not producing the max date of each record. What can I do? 

ID | date (V_string)

1   | 06/01/2012

1   | 12/03/2011

When I use the max function in summarize tool i get --> 12/03/2011 and i want to get 06/01/2012

[JamesCharnley]

Hi @fitch1892,

Do you have a specific reason this needs to be a string and not a date? I'd expect it would even be easier to turn it into a date, find the maximum and turn it back into a string than hard code some string calculation. It's returning 12/03/2011 at the moment simply because 1 is bigger than 0.

[Felipe_Ribeir0 · Accepted solution]

Hi @fitch1892 

For this to work, you must convert your date(string) to a date format:

[fitch1892]

When I do that, some of my records turn out NULL() when they shouldn't be.

[Felipe_Ribeir0]

@fitch1892 

Try one time with the above and one time with the bellow formula:

datetimeparse([date], '%d/%m/%Y')

datetimeparse([date], '%m/%d/%Y')

If you still getting errors after that, could you please share how the null cell data looks like before the formula?

[fitch1892]

Thank you. I decided to use 'DateTime' tool and it worked for me.