Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
im using now() as a new column(refreshed_date) in Dataset to indicate dataset last refresh date,
but I want to keep only date in 'yyy-mm-dd ' format and truncate the timestamp, or if I have to keep timestamp I want it to be at UTC timezone level.
how can I achieve it ? Please help
Hi,
You can use now().toString('yyyy-MM-dd') to keep only the date part. The results are always in local timezone in Formula.