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?
Page 1 / 1
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
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
Thanks Adam. I'm currently using
DATEADD(DATETIME_PARSE(LEFT(NOW(),10)),11,"h")
It's driving me nuts and no doubt I'll have to adjust the formula as the day goes on... you somehow have to remove the time from the result so that only the date remains.
It would be nice if Airtable provided a date only field rather than datetime.
I've also noticed that with a calculated date you have an option to remove the time from the display and still select the timezone however with a date field when you remove the time you no longer have the timezome selection. Another odd one is that the sample output shows the correct date.
I've also noticed that with a calculated date you have an option to remove the time from the display and still select the timezone however with a date field when you remove the time you no longer have the timezome selection. Another odd one is that the sample output shows the correct date.
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.
Thanks Adam. I'm currently using
DATEADD(DATETIME_PARSE(LEFT(NOW(),10)),11,"h")
It's driving me nuts and no doubt I'll have to adjust the formula as the day goes on... you somehow have to remove the time from the result so that only the date remains.
It would be nice if Airtable provided a date only field rather than datetime.
I've also noticed that with a calculated date you have an option to remove the time from the display and still select the timezone however with a date field when you remove the time you no longer have the timezome selection. Another odd one is that the sample output shows the correct date.
I've also noticed that with a calculated date you have an option to remove the time from the display and still select the timezone however with a date field when you remove the time you no longer have the timezome selection. Another odd one is that the sample output shows the correct date.
Yeah, it's a bit of a headache. Glad you managed to figure a solution out though even if it's pretty painful!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.