Skip to main content
Topics#Ask An ExpertTara Cooksey's Question
Tara Cooksey (OneAmerica) asked in #Ask An Expert
Dec 11, 2019, 8:06 PM

Prevent Null when one date in a resource formula is not populated

Hello all.  I have a resource formula in a flow that takes Date A - Date B.  If one of the dates is blank, the formula evaluates to NULL.  Is it possible for the formula to evaluate to zero if one of the dates is blank? I ask because we use this formula as criteria in a decision in the flow.  When one of the dates is blank, it triggers the incorrect outcome. To prevent that, I used a NULL check, but now that is triggering the incorrect outcome in some instances.  It is possible for one of the dates to be blank. 
4 answers
  1. Narender Singh (-)
    Dec 11, 2019, 9:19 PM

    The formula should look like this:

    IF( 
    OR( 
       ISBLANK({!DateAvariable}), 
       ISBLANK({!DateBvariable)}) 
       ), 
    0, 
    DateA-DateB)

     

     
Write an answer...
0/9000