Comparing Dates Using Conditional Statements

Plan availability	All plan types
Permissions	Owner /Creator - Have access to all field configuration options. Additionally everything editors, commenters, or read-only users can do. Editor - Can sort by, filter by, group by, or hide the field within a view. Commenter / Read-only - Copy a field's URL
Platform(s)	Web/Browser, Mac app, and Windows app

This article covers how to compare dates using conditional statements in Airtable formula fields.

Comparing dates against one another

Using an IF statement is a quick way to compare two dates. The formula below will compare both dates, and return the second date only if it is greater than the first date, and otherwise show a blank value.

IF({Date 2} > {Date 1}, {Date 2},BLANK())

Output values depending on date comparisons

For another approach, you may want to measure the days between the current date and time, and a static date field (like the date the invoice was billed). Adding in a conditional IF statement allows you to do the following:

If the payment received field is empty
And the days passed between the current day and the day the invoice was billed is more than 25 days
Then output a message to send the customer a reminder
And if none of the above is true, output a blank value

IF(
  AND({Payment Received}=BLANK(), 
   DATETIME_DIFF(NOW(),
    {Invoice Billed}, 
     'days') > 25), 
   "Send customer reminder"
  )

Comparing dates using conditional statements in Airtable

Comparing dates against one another

Output values depending on date comparisons