Skip to main content

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'

)

Reply


Terms & Conditions