Hi, I am having some trouble using the multi-field formula reformat a date from a string to an actual date data type. I have a few different dates all coming in as strings that are in different formats, and I would like to use the multi-field formula tool to convert them all to date data type.
Here are the two different string formats.
GL Date Open Date
2007/11/30 00:00:00; 1/17/2008;
When I run these two fields through the multi-field formula (DateTimeParse([_CurrentField_],'%Y/%m/$m')), I get:
GL Date Open Date
2007-11-01 Null
Thanks very much for your time.
Solved! Go to Solution.
The formula you tried recognizes only a specifc format... I would recommend trying the BB-Date macro, which can parse numerous variations of date/datetime formats.
That is perfect, thank you very much for pointing that out.
I might bring up to someone at alteryx that I spent a lot of time googling for something like this. I guess I should just come to the message board first for this sort of thing.
Thank you again.