Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

What is the Excel DateValue Equivalent to in AirTable?

Topic Labels: Formulas
Solved
Jump to Solution
179 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Accepted Solutions

You can use a combination of the IS_BEFORE() and IS_AFTER() functions. They are documented in the formula field reference

See Solution in Thread

2 Replies 2

You can use a combination of the IS_BEFORE() and IS_AFTER() functions. They are documented in the formula field reference

Thank you so much! it worked!