access 2003 date problem

eyalco

Registered User.
Local time
Today, 04:17
Joined
Jul 24, 2007
Messages
50
I have an attendance form where I write the date' entry hours and dept. hours and get a summation of worker's hours per day, salary etc'.

I recently updated from access 2000 to 2003 - I didn't have this kind of proclem in the past.

The problem : I punch in 08/11/08 (without the /) - the 8th is the day, 11th the month etc.
What I get in the table is this : 11/8/2013.

Anyone have any idea to help please?

Thanks
 
You need to change the system settings for UK dates format, not US.
 
Thanks.
It works.
:)
 

Users who are viewing this thread

Back
Top Bottom