Parsing Out Last Date when dates are entered in different formats

[michsherm]

Trying to parse out the last date for each contact but the dates are all listed in inconsistent ways. Any suggestions using RegEx?

Contact	Date
AA	18 March, 2020 27 March  3 April
BB	3/30/2020
CC	3/23/2020  4/6/2020
DD	3/18/20 & 3/23/20

[BrandonB]

You can split the rows off to different streams with filter tools when you have an & between the dates, a comma in the dates, a space between them, etc. Then these dates can be split on the delimiter. However, I am not sure about how to handle rows like the first one where you have multiple formats in the same cell. 

[AbhilashR · Accepted solution]

Hi @michsherm, what would be the year for dates mentioned in first row (contact AA)? Broadly, I would parse out the individual dates into multiple rows to structure the data into unique key value pairs of Contact and Date, convert date string into standard Alteryx date format, finally filtering out the last date. 

Attached is an implementation of the approach. Hope this helps.