[thelist] Inserting dates and booleans into MS Access

[Tim Burgan]

Hi Michael,

Michael Pemberton wrote:

> MySQL requires that the date be in the format of YYYY-MM-DD.  So, 
> after using mkdate(), use date() to format the data into the required 
> format.


I tried:
date(mktime($month,$day,$year));
but PHP still returned a data type mismatch error.

Thank you for taking the time to assist. I found a solution to my 
problems by following the email by Jay Blanchard.

Thanks again everyone.

Tim