The date of form submitted in automation shows incorrect date

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.

Create a new field of “Created Time” type.

1 Like

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

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.

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

2 Likes

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

1 Like

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