I'm trying to use the DBI module to insert values into MS Access. I found that binding variables is the best way as it inserts memo fields properly. However, I'm having trouble insert the date.

In the code below, I have tried using functions like to_date or just date before the ?. I also tried &{"DBI::SQL_DATE"} but it gives me error DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification (SQL-22018).

The date values are in 5,8 and 9 of the array i.e bind values 6, 10, 11.

Does anyone know the best way to format dates for MS Access using the Perl DBI Module?