Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find by Age
Message
From
13/08/2007 09:45:14
 
 
To
13/08/2007 09:35:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01247806
Message ID:
01247812
Views:
9
>Dear Experts
>
>Table1 has following two fields as
>name c(30) && employee name
>birth d(8) && date of birth
>
>data in table is as
>
>eric-------01/01/1975
>Gomez--05/12/1980
>Bush----03/11/2000
>Jack-----27/03/2005
>XYZ------12/10/1970
>
>I want to brows those employees their age is less than or equal to 35 year.
>
>Please help
lDate=gomonth(date(),-12*31)
Select * from yourtable where dateofbirth<=lDate
Previous
Reply
Map
View

Click here to load this message in the networking platform