Format Custom Date into ISO

[AnishaUFL]

Hi All,

My dataset has a unique date format, and I can't seem to figure out how to change it into ISO. For example, the dates in my dataset are "3rd of June, 2023" or "26th of April, 2022." Any advice would be greatly appreciated!

[Yoshiro_Fujimori]

Hi @AnishaUFL ,

I would remove the "st, nd, rd, th" after the days first, and then apply DateTimeParse() as below.

[Date] = REGEX_Replace([Date], "(\d{1,2})(st|nd|rd|th)(.*)", "$1,$3")

[Date2] = DateTimeParse([Date],"%d, of %b, %Y")

I hope this helps.

[Qiu]

@AnishaUFL 
Apparently, we can use Wild card in the DateTime Parse function as mentioned in here.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Converting-a-date-format/td-p/...

[AnishaUFL]

@Yoshiro_Fujimori  For some reason, when I try it on my actual dataset, the data preview and the results box come up empty. The field names are the same.

[AnishaUFL]

@Qiu For some reason, when I try it on my actual dataset, the data preview and the results box come up empty. The field names are the same.

[Qiu]

@AnishaUFL 
What is your actualy data looking like?