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.
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