Date Problems dd/mm/yyyy - mm/dd/yyyy

surethom

New member
Local time
Today, 06:48
Joined
May 2, 2012
Messages
6
I have a very strange problem, I have a field set to date Format: Short date, Input mask 00/00/0000;;_ on Every Windows 7 PC I enter a date i.e. Today 01/09/2014 & that date stays at that format but on the 1 pc i am having a problems with, Windows Vista PC when I enter 01/09/2014 it changes to 09/01/2014, but if I enter 13/09/2014 it stays as 13/09/2014???

I have check the clock setting & all the regional setting in control panel & they all say British English/ UK

Im not sure what is happening on the 1 PC & where or what else to check - any ideas please
 
If you change the format to: dd-mmm-yyyy what results are you getting?
 
Not that does not help, if I put the format to dd/mmm/yyyy then enter 01/09/2014 it automatically changes the date to 09/01/2014 Which is extremely puzzling.

Help:banghead:
 
Recently, from another group:

In the GUI, the date format is always localized except if you specify another format in the Format property.
In VBA and SQL, date string expressions are always read in US, then local, then ISO format until a match.
For CDate and DateValue, however, the sequence is local, US, ISO.
For ADO and FindFirst, only the ISO format is reliable.

The workaround in SQL code is always to use the ISO format: yyyy-mm-dd.
It will never fail.
 
US vs NL euro formatting of dates. Access requires/expects US Formats thus 01/09/2014 is actually Jan/9/2014, right down to 12/9 being Dec/9

However 13/9, 13 doesnt exist as a month, which is why access fails at converting it MM/DD and actually converts it DD/MM
 
US vs NL euro formatting of dates. Access requires/expects US Formats thus 01/09/2014 is actually Jan/9/2014, right down to 12/9 being Dec/9

However 13/9, 13 doesnt exist as a month, which is why access fails at converting it MM/DD and actually converts it DD/MM

As jdraw's post stated , this is not true in the GUI and the poster is having no trouble on the other machines, although the behaviour is very symptomatic of what you describe, ie it is expecting US date format input.

Brian
 

Users who are viewing this thread

Back
Top Bottom