Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 17, 2022 10:25 AM
It is currently the 18th Dec in NZ. The field I have called TodayNZ is a calc "Today()". It is formatted as NZ time zone. Is there any reason why it comes up as the 17th Dec?
Dec 18, 2022 12:07 AM
The value for "TODAY()" is set to GMT+0 on the server. I think what may be happening is that it's technically still the 17th on GMT+0, and so the value of `TODAY()` is 17 Dec, 12am GMT+0
With that field set to Pacific/Auckland, it's +13, so 12am + 13 hours = 17 Dec 1pm
You could try doing a formula field of `DATEADD(TODAY(), 13, 'hours')` perhaps? Don't take my word for it though, timezone stuff makes me go crosseyed heh
Dec 18, 2022 11:15 AM
Thanks Adam. I'm currently using
Dec 18, 2022 11:22 AM
As per above comment, when you have a calculated date and remove the time, the timezone is still selectable however when it's a date field and the time is removed, the timezone cannot be selected.
Dec 20, 2022 07:34 AM
Yeah, it's a bit of a headache. Glad you managed to figure a solution out though even if it's pretty painful!