I have a db_field storing date of birth (DOB), I would like a user to be able to pull out all records where the DOB means that they are the age that the use has entered as search criteria.
Confused??? I am!!!!!!!
Any suggestions greatfully recieved.
Moderator: General Moderators
Code: Select all
SELECT * FROM blah WHERE dob BETWEEN '1969-05-24' AND '1972-09-12'