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

Simple Search Date Formula

Topic Labels: Formulas
252 0
Showing results for 
Search instead for 
Did you mean: 

I need a simple formula that will find a specific date

AirTable Date Field is formated as ‘2021-06-10’ or ‘YYYY-MM-DD’

I can’t seem to get the right formula to find a specific date

IF(Date = 2021-06-10, TRUE())

IF(Date = '2021-06-10', TRUE())

Neither one works. Please help.

Edit: I think I found the solution

IF(Date = DATETIME_PARSE('2021-06-10'), TRUE())
0 Replies 0