Date Format

[badgeeta]

I am currently working with UK dates dd/mm/yyyy and have the following problem:

In my tables I have set the date to datetime. When a user inputs the date 03/02/2007 it writes back to the table as 02/03/2007 (US date). However, when they input 13/02/2007 it remains 13/02/2007 (this is because the day is over 12 and is therefore not recognised as a month).

[r035198x]

I am currently working with UK dates dd/mm/yyyy and have the following problem:

In my tables I have set the date to datetime. When a user inputs the date 03/02/2007 it writes back to the table as 02/03/2007 (US date). However, when they input 13/02/2007 it remains 13/02/2007 (this is because the day is over 12 and is therefore not recognised as a month).

What is the problem?
What platform/language are you working in? You should post this in a more relevant forum.

[MMcCarthy]

I am assuming this is Access related as it is a recognised Access issue and I am therefore moving this question to the Access forum.

ADMIN