Skip to main content

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

Hi @Lucas_Tjahjadi and welcome to the community!



What do you mean by “recorded time”?

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

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.

Reply


Terms & Conditions