date format problem

[Damon Greives]

Hi
In an A2k database running on a LAN with Win98 PCs some of them store dates
in a weird format. They are all set for UK date format dd/mm/yyyy but some
seem to transpose the day and year so that 14 July 2004 will appear as
4/07/2014.
Has anyone seen this before? The PCs were recently upgraded from win95.
TIA
Damon

[Allen Browne]

There are 3 cases where Access can misunderstand your dd/mm/yyyy format.

Details on how to prevent it in:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Damon Greives" <[e-mail]> wrote in message
news:40******@news.comindico.com.au...

In an A2k database running on a LAN with Win98 PCs some of them store dates in a weird format. They are all set for UK date format dd/mm/yyyy but some
seem to transpose the day and year so that 14 July 2004 will appear as
4/07/2014.
Has anyone seen this before? The PCs were recently upgraded from win95.

[Keith Wilby]

"Damon Greives" <[e-mail]> wrote:

In an A2k database running on a LAN with Win98 PCs some of them store
dates in a weird format. They are all set for UK date format dd/mm/yyyy
but some seem to transpose the day and year so that 14 July 2004 will
appear as 4/07/2014.

I've sometimes seen this happen when an invalid date is entered, eg 31 Sep
2004 might come out as 09/04/1931. Have you also checked the text boxes
for non-UK formatting?

Regards,
Keith.