How can i force access to see all dates as uk format

[jamiec1]

It treats 01/02/2001 as the 2nd of jan which is a huge pain .. any way to force it to see all dates as being uk format .. my regional settings are set to uk so it cant be that.
thanks

 

[DJN]

Format the date field in the table as dd/mm/yyyy if you want the full date, e.g. 06/11/2001 or format the date as Short Date for 06/11/01

 

[jamiec1]

The problem is that if i am running a query where there are 2 dates say 30/01/2001 and 06/05/2001 it sees the first as 30th jan and the second as 5th june even it they are in the table in format shown above.

 

[DJN]

Hi jamie,
If you are still getting the wrong format in the query, and I don't see why that should be, add the formatting to the field in the query.

AliasName: Format([YourDateFieldName],"dd/mm/yyyy&quot

 

[jamiec1]

That doesnt help it still sees 01/05/2001 as 5th of jan all the format is doing is reformating it .. I need to make access see that date as 1st of june ie see all dates as uk format and not default to US. I am not even using a recordset to test just a simple datediff on 2 dates it just tries to default to us all the time

 

[nickjar2]

Check your regional settings in control panel. U shouldn't be getting this problem (apart from using dates in SQL) Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[jamiec1]

Regional setting was the first thing i checked . Its all set to uk

 

[mymou]

Hi jamiec1

Had this problem as well - everything fine - except in the SQL.

Can't remember exactly - but the solution I used was to format the date in code. Using form dd/mmmm/yyyy - means that there can be no ambiguity.

Far from a perfect solution - but does help on internationalisation issues I guess.

Keep me posted if you find out what the 'real' issue is.


Stew