Help

Simple Search Date Formula

Topic Labels: Formulas
990 1
cancel
Showing results for 
Search instead for 
Did you mean: 
slyfox
6 - Interface Innovator
6 - Interface Innovator

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())
1 Reply 1
sabbir
4 - Data Explorer
4 - Data Explorer

thanks that works