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

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

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.