Hi,
How do i convert this column into mm/dd/yyyy format ? I was trying the custom format, but it left the yyyy-mm-dd ones unconverted.
Thanks!
Solved! Go to Solution.
A quick way would be a filter tool where Contains([date],"/") and then use a date tool from the true with the one format and a date tool from the false with the other format, and then union both of them afterwards. This way you would standardize all dates to an actual date format. Then you could use another date tool at the end which converts a date format to the string format of your choice where you could specify mm/dd/yyyy as you would like.
Hi @vvei ,
you should use a formula tool and convert in a first step to a Date format using DateTimeParse depending on the seperator (IF "-" then "%Y-%m-%d" ELSE "%d/%m/%Y"). In a second step you can create the format you need using DateTimeFormat. See attached workflow.
In addition, there are some NULL values and strings in the column, I added a filter tool to eliminate.
Best regards
Roland
Thank you @BrandonB !
Thank you @RolandSchubert !
This is helpful! Thank you!!
This also works well! Thank you @TerryT