>I have a "student_admi.dbf" with fields 1. id 2. name 3. dob 4. category 5. phymark 6. mathsmark 6.optionalmark, having total 1000 records. I want to prepare the error list of the students based on the "dob" field whose age above 21 years as on 1st July 2009.
>
>
>How to write code?
SELECT * FROM student_admi WHERE dob<GOMONTH((DATE(2009,07,01)),-12*21) AND !EMPTY(dob)
Brandon Harker
Sebae Data Solutions