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.
@Asad_Ali110 one way of doing this