Age from DateofBirth query

[jkscript]

I have a table with a dateofbirth field. I have a query which has a calculated field "Age: Int(DateDiff("d", DOB, Date)/365.25)".

This works fine.

I then add criteria to limit the age to a specific range like "BETWEEN 21 AND 50".

Strange thing is, it works fine, but after about 1.5 seconds an error message "Data type mismatch in criteria expression" appears.

I am at a loss.

 

[LJtechnical]

Is the Date of birth stored in table as text or number? Maybe this is the problem.

 

[danvlas]

If DOB is stored as text, you probably have a 'bad' date in a record. A separator might be misplaced...

If not, you may have a Null value somewhere in that field.

Out of curiosity: What's the mathematical/logical background for the formula?






Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html