Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Doctor Doom
Starting Member
12 Posts |
 Posted - 2004-05-13 : 08:10:14
|
the weirdest thing I ever met in MS Access:I copied and pasted an SQL-code on the sql-window in ms Acces, within that code this piece: "...Between #1/1/2004# and #5/1/2004#..." (thus: between 1 januari and 5 januari)When executing, I see that Access changed values with dates between 1/1/2004 and 1/5/2004 (between 1 januari and 5 may)I check the code of the sql: the dates between de actual code window is completely different from that on the design window, Access switched the day and the month (without my persmission  )...What the...?Can anybody help me to solve this stupid problem?Thanks very much in advance! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-05-13 : 08:21:28
|
| Yeah, Microsoft products usually default to a U.S. date format, and sometimes the regional settings are ignored. SQL Server and Access will interpret these differently, so you can't just cut-and-paste code between them.Try using the ISO date format (yyyymmdd), SQL Server always interprets this correctly, and I think Access will too. |
 |
|
|
|
|
|
switch the day and time in sql