MS Access date formats

By brendan.donaghy ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

I've seen similar a couple of times

by Tony Hopkinson In reply to MS Access date formats

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.

Collapse -

I agree

by Maevinn In reply to MS Access date formats

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.

Collapse -

Thanks guys

by brendan.donaghy In reply to I agree

It's clearly not unheard of. I'll keep looking.

Related Discussions

Related Forums