Recognizing Date Entered as DD/MM/YY

WinIDS

New member
Local time
Yesterday, 21:09
Joined
Jan 21, 2011
Messages
6
Hi all,

I currently have a query designed to return the records for a range of dates.

Criteria:
Between [Enter Date] And DateAdd("d",1,[Enter Date])

The main problem with this is that the user enters the data in dd/mm/yy, but the system records it as being mm/dd/yy instead.

Is there any way to get Access to accept this as dd/mm/yy?
 
Access works with dates according to the Regional settings of the computer. Change this setting in Windows. Why would you have the entry format different from the regional setting?

If you do need to enter in a format other than the sytem regional setting then you will have to enter a text string and parse it.
 
When working with queries you must supply a non-ambiguous format for it to work. Usually that either entails formatting as a U.S. date format (mm/dd/yyyy) or using something like 4 Jun 2010. Take a look here and see more about this issue.
 

Users who are viewing this thread

Back
Top Bottom