Date column Formatting

[Asad_Ali110]

Hi Guys,

I have a date column coming in as string format as shown below

13/12/2023	16,437,454
30-Sep-23	301,519
2022-07-17 00:00:00	12,242,586

in order to convert it, I am using the following formula:

"IF IsNull([PAYMENT_DATE]) THEN "" ELSE

IF Contains([PAYMENT_DATE], "/") THEN DateTimeParse([PAYMENT_DATE],'%d/%m/%Y') ELSE

DateTimeParse([PAYMENT_DATE],'%Y-%m-%d') ENDIF ENDIF

"

I know I am missing the bit for the date shown as "DD-MMM-YY", appreciate your help in correcting this formula.

[binu_acs]

@Asad_Ali110 one way of doing this