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";
35, Drumillan Hill
Greenock PA16 0XD
Tel 01475 798106
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 <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php