Inserting Date of Birth into Database
Hello, wonderful helpful people.
I've got a register form, in which people input things like username, password, etc. At the moment, for the date of birth, I've just got it as a regular date field which is really useless as it comes up with a calendar showing the current month and it's gona take everyone ages to find their DOB on that!
I would like to have the standard three separate drop downs for day, month, year - but I'm having trouble thinking - would these have to be all separate values inserting into separate columns in my user table in my database?
How would I merge them all together so they'd fit into my one DOB column?
Should my Access database field be a 'date' type, or just a regular text?
Thanks for any light you can shed, it is very much appreciated.