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
Solved! Go to 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!