Skip to main content

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())

thanks that works

 


Reply