Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access/SQL Server day/month switch error

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
I have experienced the same problem in both Access and SQL Server.
Using the UK date system <%Session.LCID = 2057%>
things are fine until the day matches the month (ie: 2nd Feb, 12th Dec). After that, the day and month are switched whenever a record is added or amended.
I remember seeing something about this on the MS support site months ago, but have been unable to relocate it.
Any ideas?
 
Status
Not open for further replies.

Similar threads

bslintx2021
  • Locked
  • Question
How to configure IIS 10 server to allow Classic ASP to connect to MSSQL server database on a domain
Replies
1
Views
825
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
Problem: sql-Select with request.form
2
Replies
22
Views
466
leifoet
leifoet
Krus1972
  • Locked
  • Question
msxml3.dll error '80072f7d' - An error occurred in the secure Channel support
Replies
7
Views
587
Krus1972
Krus1972
leifoet
  • Locked
  • Question
Using date picker gives an error message, only at application start
Replies
1
Views
385
MarkSweetland
MarkSweetland
leifoet
  • Locked
  • Question
Classic ASP multiple record update with Access
Replies
7
Views
344
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top