Skip to main content
Delphine LAFON (Prefikar) 님이 #Automation에 질문했습니다

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개
  1. 2021년 7월 30일 오후 2:57

    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,