Insert Date Error

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

hi

I'm having difficulty with an insert query in MS Access
2000 on an NT4 machine.

When a date is inserted and the day value is smaller than
the month value it swops the day and month values.
 
Hi Gary

See:
International Date Formats in Access
at:
http://members.iinet.net.au/~allenbrowne/ser-36.html

The article explains how dates entered in the user interface use the format
set in the Windows Control Panel under Regional Settings, but literal dates
in VBA code or SQL clauses must be entered in mm/dd/yyyy format.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Text Fields to Date Field 5
Excel Vba to change displayed year automatically. 14
Date Format in a Query 5
Append Union Queries 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
How to replace a date in an insert query? 5
Insert query by using VBA in Access 1
Excel Message box with days of month & date. 1

Back
Top