entering date in a table using query

  • Thread starter Thread starter prakash
  • Start date Start date
P

prakash

hi friends,
while entering 'date' in a table i had this strange
experience. If I enter a 'date' for eg:12/3/1998, in a
table using sql, the table shows some other date. This
does not happen when I enter a 'date' directly in the
table. could some one please direct me as to what could be
done to enter a 'date' in a table using SQL, without
the 'date' getting changed?
 
Literal dates in a SQL statement will be interpreted in mm/dd/yyyy.

Dates entered through the interface will be interpreted according to your
reginal settings.

More info:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
 
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

Help needed to create a query 0
Another most-recent date query 0
Access query for last date entered 4
Output a user entered value 3
Combine Duplicates in Query 0
Date query 2
Make table query: [Enter 1] AS Test 1
Query on or before date 2

Back
Top