Question Locked

MS Access date formats

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a MS Access application on a central server available via Citrix to 30 or so users.
Two of these users are seeing their dates displayed in 'American' format mm/dd/yyyy. The others are all OK. I have checked one of the 2 PCs - the regional settings look OK (English(UK)). Short of a virus, what else can affect this? Grateful for anything.

4 replies

by tony hopkinson

On one of them the regional setting was UK, but the short date format was mm/dd/yyyy.

Took me a while to spot that.

The other I have no explanation for, according to the PC everything should have been english, but it wasn't.

In my code I never trust locale anymore if it's only for the UK market I force the data over.

by maevinn

Maybe the regional settings have been customized. I've had a number of problems related to how date fields are interpreted based on regional settings.

This discussion is closed to new replies.