---
title: "Comparing Dates Using Conditional Statements | Airtable Support"
slug: "comparing-dates-using-conditional-statements"
description: "This article covers how to compare dates using conditional statements in Airtable."
tags: ["Conditional statements "]
updated: 2025-12-01T18:00:54Z
published: 2025-12-01T18:00:54Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.airtable.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Comparing dates using conditional statements in Airtable

| **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())`

![360056980473ScreenShot2020-01-27at53417PM.jpg](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/360056980473ScreenShot2020-01-27at53417PM.jpg)

## 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

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

![360056111174ScreenShot2020-01-27at55323PM.jpg](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/360056111174ScreenShot2020-01-27at55323PM.jpg)