Skip to main content

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 respuestas
  1. 30 jul 2021, 2:57 p.m.

    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,