Date Conversion Question

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?


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”)


Thanks man, you are a legend! :grinning:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.