ok, I see it......yea, adding the Date() does fix the error messg...thank you :D
now, if could ask you one final question.....how do I get the function to return "not available" if one of the two dates is null?
I've tried and i get a mismatch error
BegDate = CDate(Nz(BegDate,"not...