Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

If date equals not working

Topic Labels: Formulas
2427 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