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

[zodeci]

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

[JonathanBowen]

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