Passing a null date into a function (1 Viewer)

[rosenn]

I have written a small function that accepts two dates and a string, and returns a string. If one of the dates is null, no matter what the other one is or what I do in the body of the function, the function returns '#Erreur' - regardless of if I check with 'IsNull', even if the routine never even utilizes the null date in any operations and the function exits, same thing.

Any ideas?

-Nelson Rosen

 

[boblarson]

You want to utilize the NZ() function. You will then be able to define what you want the calculation to use if a null value exists.

Look for NZ in the help file.

BL
hth