Unable to set timezone correctly for TODAY()

#1

Hey guys,

I have a quick question, looks like a straight forward one.

I have a simple {Due Date} field which is of type Date. I’ve created a new field {Due Date?} which simply calculates to {Due Date} if the {Due Date}'s value is present, else calculates to TODAY() if {Due Date} field is empty.

{Due Date?} is a formula field and here’s the formula:-

IF({Due Date} != "", {Due Date}, SET_TIMEZONE(TODAY(), 'America/Los_Angeles'))

However, I am in America/Log_Angeles, time is around 8:30pm on April 10, however, I see field being populated as April 11 which is probably UTC time.

What am I doing wrong?

0 Likes

#2

When making a formula field that returns a date, Airtable sometimes assumes that you want GMT. Check the Formatting tab when editing the formula field details, and you might see the GMT option switched on.

1 Like

#3

Thank you @Justin_Barrett, that was indeed the case.

0 Likes