Help

The date of form submitted in automation shows incorrect date

Solved
Jump to Solution
1970 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Chia_Mi
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions

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.

See Solution in Thread

4 Replies 4

Create a new field of “Created Time” type.

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
截圖 2021-11-17 上午7.28.45

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.

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