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
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
Thank you IraWatt and messi007