Extract the latest date

[DanielCarro]

Hi,

I need some help, I need to extract the most updated date.

For example:

ITME	DATE
A	14/03/2001
A	17/05/2005
A	19/11/2006
B	02/10/2003
B	12/12/2006
B	06/07/2009
B	11/12/2011
C	07/11/2000
C	02/05/2010

Expected Result to be

ITEM	DATE
A	19/11/2006
B	11/12/2011
C	02/05/2010

Note: the dates can be in random order

Regards,

DAN

[messi007]

@DanielCarro;

Please see below 

Attached the workflow,

Regards

[IraWatt]

Hey @DanielCarro,

Here is one way to do this:

First I change your text dates to a date data type using the datetime tool. Then I used a sumerize tool to get the max date for each item.

Any questions or issues please ask :)
HTH!
Ira

[DanielCarro]

Thank you IraWatt and messi007

[SriNarendra]

Change the Date type by using the datetime tool then use the summaries tool to get the max date for each item