Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Date-Based IF Statement

Topic Labels: Formulas
Solved
Jump to Solution
304 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi!

I have a project management base with a series of dates for different stages of the production process. I want to have a series of corresponding “Function” fields that would flip to “Past Due” when a deadline passes. I am very new to Airtable and have had difficulty with writing date-based formulas.

Thanks in advance!

1 Solution

Accepted Solutions

Hey @Shayan_Saalabi, welcome to the community!

You can use a formula like the one below for this. Note that I used Deadline as the field name (you’ll see it referenced within curly brackets) so you’ll need to adjust that based on the name of your date field.

IF(
   AND(
      {Deadline},
      NOW()>{Deadline}
   ), 
   "Past Due"
)

Here’s an outline of the formula logic:

  • If the {Deadline} field has a date entered
  • And that date is after the current date/time (signified by the NOW() function)
  • Then show the message “Past Due”
  • Otherwise, showing nothing

Hope that helps! I’d also recommend browsing through our formula resources here in our support center.

See Solution in Thread

1 Reply 1

Hey @Shayan_Saalabi, welcome to the community!

You can use a formula like the one below for this. Note that I used Deadline as the field name (you’ll see it referenced within curly brackets) so you’ll need to adjust that based on the name of your date field.

IF(
   AND(
      {Deadline},
      NOW()>{Deadline}
   ), 
   "Past Due"
)

Here’s an outline of the formula logic:

  • If the {Deadline} field has a date entered
  • And that date is after the current date/time (signified by the NOW() function)
  • Then show the message “Past Due”
  • Otherwise, showing nothing

Hope that helps! I’d also recommend browsing through our formula resources here in our support center.