Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Subtracting Dates
Message
From
23/11/1999 13:37:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Subtracting Dates
Miscellaneous
Thread ID:
00294459
Message ID:
00294459
Views:
64
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
Map
View

Click here to load this message in the networking platform