Date and time format

[dmn]

Hi,

A form from fastpages.io records a date that is in this format 1/9/2022 into my google sheet when it is supposed to be 9/1/2022 (month, day, year). How can I change that?

 

[Pabbly]

You can make use of data/time formatter for the same -

 

[dmn]

Thank you

 

[PabblyMember4]

You're welcome