Inserting Dates Into Naviison

I’m trying to do a sql insert into Navison with ASP/Java and ODBC, it’s working apart from the date fields, has anybody any ideas what format I should be using, I’ve been using all the obvious. Any help much appreciated.

Does the insert not work at all, or are you getting the wrong date? Please remember that the definition of SQL specifies to use the American notation (mmddyyyy) for dates. Your sending code should convert the date into this format. John