MS Forms Flow Date Convert

[KJC]

Hi,

I have created a simple Flow (Form to email). I have a date question in the form but Flow converts the date incorrectly (YY/MM/DD). I need it to display DD/MM/YY. Can anyone advise how I can ensure Flow has the correct date format? So on the email the date field reads  DD/MM/YY?

Many thanks

[CFernandes · Accepted solution]

Please use the function formatDateTime which can be used to return any specified format.

With reference to your requirement you can use:

formatDateTime(triggerBody()?['Date'],'dd/MM/yyyy')

 Let me know if this helps? 

[KJC]

Sorry for such a long delay in my response but I just want to say thank you, this worked!

Thanks again

Kieran

[CFernandes]

@KJC i am glad that your problem has been resolved..