Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

If date equals not working

Topic Labels: Formulas
1240 2
Showing results for 
Search instead for 
Did you mean: 

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

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

Th! Love you bro, it worked