Help

If date equals not working

Topic Labels: Formulas
2327 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Paul_Hockley
4 - Data Explorer
4 - Data Explorer

Hello! Using the current formula:
IF(DATETIME_FORMAT({Date of Outreach}, ‘DD/MM/YYYY’) = 22/07/2017, “ :white_check_mark: ”, “ :x: ”)
But for some reason it doesn’t validate when the date is 22/07/2017 in Date of Outreach field…

Any ideas why?

2 Replies 2
Christoff
7 - App Architect
7 - App Architect

Put quotation marks around the date: “22/07/2017”.

Th! Love you bro, it worked