I have a table namely "student.dbf" having fields 1. Regno (I), 2. Name (C), Caste (C), 4. DOB (Date), 5. Maths (I), 6. Physics (I), 7. Biology(I).

I want to select the records based on DOB field, whose student age is less than 17 years as on 1st December 2014 and whose student age is less than 17 years as on 1st October 2014 and whose student age is greater that 28 year as on 1st July 2014.

How to write the Query?