Date For Access ?

[Anon]

I'm fairly new to PHP, so bare with me =)

Is there a way to get the current date in Windows that is acceptable with Access' date datatype? For example, I have a field named "fldDate", and this date is set to "Date/Time" ("Long Date" format). I used the date() function to retrieve the date and stick it in a variable (that gets put in the database). But since the date() function returns a string, I got a type mis-match.

Could anybody help me with getting a date timestamp compatible with Access' "Date/Time" format?

Thanks for any help.

[trystan]

The DATETIME field that MS Access returns is a string type. To insert data into that field you must send it back to Access as a string, not doing so will cause a mismatch.

here is a small piece of code, using the MS Access "Northwind Contact" database sample.

$result = odbc_exec($link,"Insert Into calls (ContactID,CallDate) Values (1,'21/03/2002')");