Null date causes #Error

[oystercracker]

I wrote a very simple Date function with one date parameter. It is supposed to return 1/1/1999 if the parameter date is Null, else 1/1/2000. A record with a null parameter date returns #Error, while all other records return 1/1/2000 correctly. Changing the Null date in the record does eliminate the #Error. It seems as though the function simply will not accept a record with a null value in its parameter!

 

[JoeMiller]

Can you post the code so we can review it and tell you your error?

Joe Miller
joe.miller@flotech.net