Comparing dates using conditional statements in Airtable
  • 06 Sep 2024
  • 1 Minuto para leer
  • Oscuro
    Ligero
  • PDF

Comparing dates using conditional statements in Airtable

  • Oscuro
    Ligero
  • PDF

The content is currently unavailable in Spanish. You are viewing the default English version.
Resumen del artículo

Plan availability

All plan types

Platform(s)

Web/Browser, Mac app, and Windows app

Related reading

This article covers how to compare dates using conditional statements in Airtable to streamline your team's and organization's work.

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

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"
  )

360056111174ScreenShot2020-01-27at55323PM.jpg


¿Te ha sido útil este artículo?