YES! I can, that works. Thank you. I guess I was trying to be too clever and cover all the possibilities when there was no need.
Thanks again to all who offered suggestions. Regards, Alastair. ----- Original Message ----- From: "Jim Blackburn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 16, 2001 5:16 PM Subject: Re: Date fields in forms & ifnull return null questions > Alastair: > Why not try: > v1AgeNext = ( (INT( (.#Date - Birth1day) / 365 )) ) > > If Birth1day is null, the result should be null. That is what I get from a set var command. > > Jim Blackburn > Kodiak
