|
Home > Archive > MS Access data conversion > April 2005 > Problem with date
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| David Paquette 2005-04-11, 8:26 pm |
| 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 2005-04-11, 8:26 pm |
| SQL Server lets you set an explicit date format. Look up SET DATEFORMAT in
Books Online.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"David Paquette" <david. paquette@souscripteu
rs.com> wrote in message
news:OqXSOjtPFHA.3628@TK2MSFTNGP15.phx.gbl...
> 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 ?
>
>
>
|
|
|
|
|