The date of form submitted in automation shows incorrect date

[Chia_Mi]

Hi people,

Dose anyone know how to make the correct date (I need year/mm/dd and time) in my table when my form get submitted?

I tried the formula

DATETIME_FORMAT(NOW(),'YYYY-MM-DD')

also I tried

CREATED_TIME()

but the date and time shows up incorrect.

[ScottWorld]

Create a new field of “Created Time” type.

[Chia_Mi]

Thanks for help! @ScottWorld

I tried create a new field of “Created Time” type, and the automatiion date/time still not showing right.

Like this pic, the right date should be 2021-11-17 but it shows 2021-11-16

[Kamille_Parks · Accepted solution]

Turn off “Use GMT for all collaborators”. or use Date Time Format + Set Timezone to force the created time to whatever timezone you are in.

Chia_Mi:

DATETIME_FORMAT(NOW(),‘YYYY-MM-DD’)

This will show literally always “now”, plus or minus 15 or so minutes inbetween when the formula refreshes.

[Chia_Mi]

Thank you so much @Kamille_Parks

I get the right time! finally! :sparkler:

For those who might having the same problem like me, here is the solution I use:

DATETIME_FORMAT(SET_TIMEZONE({Created}, 'Asia/Taipei'),'MM-DD-YYYY hh:mm')

Also some useful sources link down below:
Supported timezones for SET_TIMEZONE

Use a formula like this to set the time zone answerd by @ScottWorld