date format for data entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple table that records form values entered from a web page.
There is a date/time field with the default mm/dd/yy format. When data is
received via the web form all appears to go well, e.g. Nov 5 2004 ==>
11/5/04, as expected.

However, when manually entering data to the same table, entering Nov 5 2004
into the field results with 5/11/04. I have tried every premutation, and
every format control in design/data view etc, but the sill thing insists on
"reversing" Nov 5 to May 11th, when the data is entered manually (either
typed or copy/paste). Please advise.
 
What is the Short Date format set to (through Regional Settings) on the
machine where this is happening?
 
The PC's short date is set to M/d/yyyy.

Douglas J. Steele said:
What is the Short Date format set to (through Regional Settings) on the
machine where this is happening?
Click to expand...
 
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

Changing Data format 3
Can't format a text box 5
Datepicker issue after changing Windows' short date time format 5
Error with dates 4
yet another date format problem 1
date difference in days between birthdate and now 3
Enter Date Format 9
Count the highest number of days without “errors” 2

Back
Top