Help

Formula Primary Field ( Recorded Time)

Topic Labels: Formulas
Solved
Jump to Solution
1523 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucas_Tjahjadi
5 - Automation Enthusiast
5 - Automation Enthusiast

Hai everyone, how to write formula on primary key column to capture Recorded time.
I know there is column with type created time, but for primary key I’m not using so I think will be better if use for recorded time but with formula

Thank you

1 Solution

Accepted Solutions

Try

DATETIME_FORMAT(SET_TIMEZONE(NOW(), "Asia/Jakarta"),"YYYY-MM-DD -LTS")

You can find the list with supported timezone identifiers here.

See Solution in Thread

3 Replies 3

Hi @Lucas_Tjahjadi and welcome to the community!

What do you mean by “recorded time”?

Hi, I mean for created time and date with time zone Asia, Jakarta.
My formula is `

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

but with this how to add time zone?
Could you help me for this?
Thank you

Try

DATETIME_FORMAT(SET_TIMEZONE(NOW(), "Asia/Jakarta"),"YYYY-MM-DD -LTS")

You can find the list with supported timezone identifiers here.