Finding the max date that is a string

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

Datasets

Developer Tools

Custom Tools

Date Time

Accepted answers

Felipe_Ribeir0

Hi @fitch1892

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

date.yxmd

All comments

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.