Help

Date will not work correctly for New Zealand

Topic Labels: Dates & Timezones
542 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Ben_Paterson
4 - Data Explorer
4 - Data Explorer

Hi,

I am trying to create a simple automation for a ‘date completed’ field that takes todays date and inserts into the ‘date completed’ field when a certain status is selected. It seems that New Zealand will not work correctly for this whatsoever though.

The first issue is that the local selection for date formatting is not correct at all and shows the date as M/D/Y rather than D/M/Y.

The second issue I encounter is that the date is always actually a day behind. It seems to show the date in GMT rather than NZDT even when I have tried to set it to NZDT. TODAY() shows 10/17/2022 even though today it is 18/10/2022.

Can anybody help?!

1 Reply 1

You can change the format settings for date and date/time fields to display D/M/YYYY.

The issue for getting TODAY() to show the proper date is a bit more difficult. One hack is to use a formula field with `DATE_ADD(TODAY(), 1, ‘days’)