Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Extract the latest date

DanielCarro
8 - Asteroid

Hi,

 

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

 

For example:

ITMEDATE

A

14/03/2001
A17/05/2005
A19/11/2006
B02/10/2003
B12/12/2006
B06/07/2009
B11/12/2011
C07/11/2000
C02/05/2010

 

Expected Result to be

 

ITEMDATE
A19/11/2006
B11/12/2011
C02/05/2010

 

Note: the dates can be in random order

 

Regards,

DAN

3 REPLIES 3
messi007
15 - Aurora

@DanielCarro;

 

Please see below 

 

messi007_0-1658317442663.png

 

Attached the workflow,

Regards

IraWatt
17 - Castor

Hey @DanielCarro,

Here is one way to do this:

IraWatt_0-1658317450184.png

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
8 - Asteroid

Thank you IraWatt and messi007

Labels