I am creating a formula field to determine if one date field is not equal to the other. I having an issue when one of the dates is blank. It is not recognizing the blank date as not being equal to the field with a date. Can you help?
9 comments
awesome-- good tip thanks SteveMo!
Shannon, you can also write it like this (I find this format easier to read personally)...
Customer Requested Date <> Delivery Date
||
(ISBLANK(Customer Requested Date) && NOT(ISBLANK(Delivery Date)))
||
(NOT(ISBLANK(Customer Requested Date)) && ISBLANK(Delivery Date))
