Date Conversion Question

[TRX (Tony)]

Hi there,

I would like to convert a date from this format:

23/01/2020 4:15:00 PM

to this format please:

23/01/20 4:15 PM

What would be the best way to do this please?

Thanks

[Ajithkumar_P]

Hi @TRX,

Kindly use the below code to change the format of date string

DateTime.parseExact(date_var,“dd/MM/yyyy h:mm:ss tt”,Nothing,Nothing).tostring(“dd/MM/yy h:mm tt”)

Regards,
P.Ajithkumar

[TRX (Tony)]

@Ajithkumar_P

DateTime.parseExact(date_var,“dd/MM/yyyy h:mm:ss tt”,Nothing,Nothing).tostring(“dd/MM/yy h:mm tt”)

Thanks man, you are a legend!