Hello,
I need to compare 2 date fields in checkbox formula and to put true if <> but not consider <> if one of them is empty.
#Automation It will be a workaround for a criteria in my flow with a date field I should say : Next date = Today but I cannot only date value is accepted.
How can I do this?
Thanks
답변 5개
Try this
or(or(ISBLANK(Date_1__C),ISBLANK(Date_2__C)),Date_1__C <> Date_2__c)
This will check that if any of the dates is Blank then return true if both are not blank then do the comparison and give true if both are different Hope this is what you needed
let me know if this helps,