Help

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

Topic Labels: Formulas
960 1
cancel
Showing results for 
Search instead for 
Did you mean: 
lb0016
4 - Data Explorer
4 - Data Explorer

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 1
Sho
11 - Venus
11 - Venus

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.