Re: Date of Birth From Form

I had the same problem when I wanted to compare dates. After a lot of help through this forum I used dropdown boxes to ensure the dates were entered correctly, (in the UK we use dd,mm,yyy). I made each value it's own variable then merged them as follows before inserting them into a date field $eventdatestring = "$eventyear". "$eventmonth". "$eventday"; -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 afrancis@camerondesign.co.uk http://www.camerondesign.co.uk This message is sent in confidence for the addressee only. It may contain legally privileged information. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. Brandon Paul <bpaul@bmw-ok.com> wrote in message news:20020419182644.99468.qmail@pb1.pair.com... > Hey all, > > I have a credit application form, and one of the required elements is the > applicant's Date of Birth. I have "creditapp" table with a > "birthdate" > field and it is a DATE datatype. On the form, I want to be able to have > them enter their Date of Birth as "mm/dd/yyyy" and have it go into the > database properly (yyyy-mm-dd). Is there a way to do it this way, or am I > going about it wrong? Any help would be greatly appreciated. > > Thanks! > > Brandon > >