General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only