Skip to main content

If date equals not working

  • June 29, 2017
  • 2 replies
  • 22 views

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

  • Known Participant
  • June 29, 2017

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


  • Author
  • New Participant
  • July 11, 2017

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


Th! Love you bro, it worked