How can I convert this date/time format from outlook events?

[19Flash92]

Hello,

I'd like to convert this date / time format to something more readable on an output:

As currently its outputting like this:

How can I convert this into something more user friendly please?

[Sundeep_Malik]

Hey @19Flash92 

You can use formatDateTime function for this.

Use this expression:

formatDateTime(DateField,'yyyy-MM-dd')

small yyyy for year,

Capital MM for months,

small dd for date.

So, if you want other formats you can use other formats as well like

dd-MM-yyyy or dd/MM/yyyy

MM-dd-yyyy or MM/dd/yyyy

Dont use small mm, it is for minutes.

If this was the solution you were looking for accept it as the solution. And if you liked the explanation, you can give a thumbs up. It really helps. Thanks. 🙂