What is the Excel DateValue Equivalent to in AirTable?

Question

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

kuovonne · Accepted Answer

Grace_Hui:If between X and Y date, then label it as “A” else “B”.You can use a combination of the IS_BEFORE() and IS_AFTER() functions. They are documented in the formula field reference

Grace_Hui · Answer

Grace_Hui:If between X and Y date, then label it as “A” else “B”.You can use a combination of the IS_BEFORE() and IS_AFTER() functions. They are documented in the formula field referenceThank you so much! it worked!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded