Jun 20, 2022 03:18 PM
Hi - I’m looking to do an if and statement with two dates. If between X and Y date, then label it as “A” else “B”.
But I am having trouble with finding the date value equivalent in airtable.
In Excel I would do:
IF(AND(CELL1>=DATEVALUE(“04/01/2020”), CELL2<=DATEVALUE(“03/31/2021”)),“FY21”, " ")
But I can’t find the equivilant of that in airtable. I currently have the following
where timestamp = my field
IF(AND(Timestamp>=DATETIME_PARSE('04/01/2020'), Timestamp<=DATETIME_PARSE('03/31/2021')),"FY21", "")
Solved! Go to Solution.
Jun 20, 2022 03:51 PM
You can use a combination of the IS_BEFORE()
and IS_AFTER()
functions. They are documented in the formula field reference
Jun 20, 2022 03:51 PM
You can use a combination of the IS_BEFORE()
and IS_AFTER()
functions. They are documented in the formula field reference
Jun 20, 2022 10:37 PM
Thank you so much! it worked!