Problem with date

[David Paquette]

Hi, I just converted my adp project from Access 2000 to Access 2003. In the
2000 version the date written on the SQL server are OK (mm/dd/yyyy). I use
the Access 2000 in French and the SQL server is version 7 in English, and
the date is ok on the SQL server. After the conversion the date on the SQL
server is dd/mm/yyyy. I used Access 2003 in French and the same sql server
that I used with the 2000 version. The regional paramater are the same,
English (USA), but my workstation is a Windows French 2000 .

The command that insert the data in the sql server is an INSERT INTO with a
variable, this variable is a type date and receive the date from trhe sql
server. When I debug the application the variable value is mm/dd/yyy and
after the insert the value in the sql server is dd/mm/yyyy.

Does some as an idea ?

 

[Douglas J. Steele]

SQL Server lets you set an explicit date format. Look up SET DATEFORMAT in
Books Online.