I get an error when using a INSERT INTO when saving a Date Value that is in the format of German Regional Settings. How do you format the date properly for saving to MS Access date fields?

I've tried Format(myDate,"M/d/yyyy hh:mm:ss")

But it's still showing as 27.11.2003 11:11 and throwing an exception.