Date Difference

[wanzek1]

I am using the following formula:

dateDiff("d", {APTH.udReceivedDate},Minimum ({APUR.DateAssigned}, {@APRef}))

Is there a way to get it to display something even if one of the values is blank or null? I know that note every invoice has a received date but I still want it to at least display 0 instead of nothing.

Thanks!

 

[BobSuruncle]

You could try this:

If IsNull({APTH.udReceivedDate}) then 0
else
dateDiff("d", {APTH.udReceivedDate},Minimum ({APUR.DateAssigned}, {@APRef}))

Bob Suruncle

 

[wanzek1]

Thanks...I got this to work!