I’m trying to come up with a formula where if {Date Time} matches {Date}, then {abc} is displayed. Pls advise thank u
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
I’m trying to come up with a formula where if {Date Time} matches {Date}, then {abc} is displayed. Pls advise thank u
+18Hi @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'
)Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.