Skip to main content

How to use IS_BEFORE with a date field and a single custom date, not two date fields?

  • October 2, 2023
  • 1 reply
  • 210 views

Forum|alt.badge.img+1

I am trying to create a field that tells me is a date field, called Purchase Date, is before a specific date, 04/09/2023 (did/mm/yyyy, same format as the date field). This is my formula so far, but it returns a “0” (ie false) on all records so many what date I enter between the “ “ in the formula. 

IS_BEFORE({Start Date}, "04/09/2023")

How do I fix this? Thanks!

1 reply

Forum|alt.badge.img+21
  • Inspiring
  • October 2, 2023

Airtable reads "04/09/2023" as April 9, 2023.

Rewrite to either of these formats
MM/DD/YYYY
YYYY/MM/DD
or
Use DATETIME_PARSE({Start Date}, "DD/MM/YYYY") to specify the format.