[thelist] Inserting dates and booleans into MS Access

[Michael Pemberton]

Tim Burgan wrote:
> What do I need to change my data to in order to get it to successfully 
> insert into the table?
> I'm using PHP, and tried using mkdate() to create the date.. without 
> success.

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.

-- 
Michael Pemberton
evolt at mpember.net.au