Forum Discussion
Custom Column with todays date - not working as expected
Hi Experts,
I have created a custom column by adding the below formula to get today's date in the column.
Date.From(DateTime.LocalNow())
But for some reason, I cannot get the Local date as per my timezone..
Can anyone help if i have to amend the formula?
Thanks
Use Date.From(DateTimeZone.FixedLocalNow()) instead.
You can force the TZ to a specific zone using:
DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -7) (this is UTC -7 hrs)
See this page for all of the ways you can work with timezones in PQ.
3 Replies
Use Date.From(DateTimeZone.FixedLocalNow()) instead.
You can force the TZ to a specific zone using:
DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -7) (this is UTC -7 hrs)
See this page for all of the ways you can work with timezones in PQ.