Using reg to fix date

[nwatzlaf]

Hi there,

I have a date (in string format) that reads 20151007. I would like it to read 2015-10-07. I think this is a use case for reg ex but I am not sure.

Any pointers would be greatly appreciated.

Thank you for your time,

Natalia

[DataNath · Accepted solution]

Hey @nwatzlaf, there's a whole load of ways to do this - here's one approach where you just tell Alteryx the format of the incoming date in its string form and it creates an ISO date (YYYY-MM-DD) from that:

%Y denotes a 4-digit year

%m represents month

%d represents day

Hope this helps!

[nwatzlaf]

Hi @DataNath ,

Super helpful! Thanks so much!!

- Natalia