Skip to main content

Simple Search Date Formula

  • June 10, 2021
  • 1 reply
  • 10 views

Forum|alt.badge.img+1

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

Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • September 1, 2023

thanks that works