Expression Problem

[OxDavis]

I am attempting to calculate a due date via an expression that calculates 90 days from a specific field. However, if that specific field is empty, I want it to calculate off another date. I believe I have written the expression properly, but it doesn not function correctly. Here is my expression:

Expr1: IIf([Perm_Staffing Date]="",DateAdd("d",90,[Child_Removal_Date]),DateAdd("d",90,[Perm_Staffing Date]))

I can get it to calc the false criterion, but not the true one. The Perm_Staffing Date does not have an input mask. I even tried setting the default value to "", but to no avail. Any suggestions?

 

[KenHigg]

You may want to use an isnull()

IIf(isnull([Perm_Staffing Date],...)

 

[OxDavis]

I love you Thanks man, worked like a charm.

 

[KenHigg]

Cool...

(Even a blind squirrel finds a nut from time to time )