>>I can't get my dates to subtract correctly. I keep getting huge numbers. I want to subtract the system date with a birth date to get an age for that person. I am doing this in a SQL statement.
>>
>>select student.studentid, student.lname, date() - student.bdate as age
>>from student into cursor clage
>>
>>My date format is in mdy. I get numbers like 7518. How come this is happening?
>>
>>Thanks in advance,
>>Tyler G.
>
>(year(date())-year(student.bdate)-iif(student.bdate>date(),1,0)) as AGE
How could the student.bdate be greater than DATE() ? Don't you mean ...IIF(MONTH(student.bdate)>MONTH(DATE()),1,0)) ... but even that is an approximation.