Skip to main content
Solved

If Due Date is Today, Enter X in Field

  • June 19, 2022
  • 3 replies
  • 40 views
R
Forum|alt.badge.img+4

I’m trying to set up an automation that will send an email reminder at a later date to complete a task.

I have set up one column with “Due Date” another as “Today” and a third as “Send”.

I have set up the following formula that when “Due Date” = “Today” it should put an “X” in the “Send” column. My automation is set to send the email when the “Send” field is updated with an X in it. Here is the formula:
IF({Due Date} = {Today},“X”)

It did not work. I also tried:
IF(IS_SAME({Due Date},TODAY()),“X”)

That didn’t work either. Just to test it, I tried:
IF(IS_SAME({Due Date},TODAY()),“X”,“Y”)
and then all the columns filled with Y, even the one where the Due Date matched Today.

???

Best answer by ScottWorld

IF({Due Date} = Today(),"X")

This formula will work. If not, it’s probably a time zone issue. Airtable sees dates as midnight in the GMT time zone, unless otherwise specified.

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hi Robbi, that’s super interesting. I’ve created what I think is the exact same setup here and it seems to work just fine

DM me a link to your base and I can see whether I can figure it out for you

Adam, Airtable Consultant - thetimesaving.company
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • Answer
  • June 19, 2022

IF({Due Date} = Today(),"X")

This formula will work. If not, it’s probably a time zone issue. Airtable sees dates as midnight in the GMT time zone, unless otherwise specified.

R
Forum|alt.badge.img+4
  • Robbi_Behr
  • Author
  • New Participant
  • June 20, 2022

It was a time zone issue! I had been working on it at night in the EST time zone so the days didn’t match up because the time zone toggles weren’t switched, so it was tonight in the Date field and tomorrow in the Today field. :crazy_face:
It’s working now, thank you!

ScottWorld
Terms & ConditionsAccessibility statement