Date format 30th Nov 2022 Issue

Question

Hi,

I have a string data as 30th Nov 2022 and trying to converting it into date format but the result are coming out as Null.

I tried DateTimeParse and result is null as well tried the DateTime tool but not sure how to enter the customisation for this date.

Much appreciated any advice.

Kind Regards,

Dan

Christina_H · Answer

This only works for dates using "th" as the suffix, so e.g. it'll work for 30th Nov but not 1st Dec.  I would update the formula to remove all possible suffixes before converting to a date:

datetimeparse(REGEX_Replace([Date], "st|nd|rd|th", ""), '%d %b %Y')

(The replace function also removes "st" from the end of August, but %b will still convert it correctly)

DanielCarro · Answer

Hi Felipe, it worked well, thank you very much

binu_acs · Answer

@DanielCarro One way of doing this

DateTimeParse_1212.yxmd