I am looking to clean up a field that is currently in a string format and need to make it a date format. The problem is that the formats in the string field are different.
Ex:
2/21/2021 -> 02/21/2021
4/8/2021 -> 04/08/2021
05/15/2021 -> 05/15/2021
2021/06/25 -> 06/25/2021
I need to get them into a mm/dd/yyyy format and when it starts off with the year I am having trouble with that.
Solved! Go to Solution.
@bburzanko3 do they appear as all 3 combinations (dd/mm/yyyy, mm/dd/yyyy & yyyy/mm/dd), or is it just a mixture of mm/dd/yyyy & yyyy/mm/dd?
They are all either MM/dd/yyyy or yyyy/MM/dd.
Both of these worked perfectly, thank you!