Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon. Entire thread

Need assistance w/ SQL query

Name: Anonymous 2006-05-31 8:55

Using Jet-SQL (I know, flame away, as long as someone tries to help), have a table of people. One field contains their birthdate, and given user input of a pair of dates (one "low", one "high")I need to use this field to figure out who will be turning exactly X yrs old at a time between the user's given high and low dates. Any help appreciated. And while I do intend to eventually switch database solutions, until I have the spare hardware and time to implement, that is not something I can do immediately.

Name: Anonymous 2006-05-31 9:16

Alternatively, check that your input dates are being recognised in the right format. e.g. if you are entering them as dd/mm/yyyy make sure it's not interpreting them as mm/dd/yyyy

Newer Posts
Don't change these.
Name: Email:
Entire Thread Thread List