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

IF {Date:Time} matches {Date} Then {X}

Topic Labels: Formulas
306 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m trying to come up with a formula where if {Date Time} matches {Date}, then {abc} is displayed. Pls advise thank u

1 Reply 1

Hi @zodeci - you need to format both date fields to a common format - something like this:

IF(
  DATETIME_FORMAT({Date/Time}, 'DD/MM/YYYY') = DATETIME_FORMAT({Date}, 'DD/MM/YYYY'), 
  'match', 
  'no match'
)