Problem With Dates

[manoj9849967222]

Hi All

I have a problem with date format. I have designed a form where i have a colum called "Date". I have changed the format to "dd/mm/yyyy" in the form as well as in the Table. Now when i enter the date in the date field say if i enter " 31/7/2007" its works it takes it in the dd/mm/yyyy format but when i enter 07/06/2007 where 7 is date & 6 is month & 2007 is year. It automatically takes it as 06/07/2007.

I dont know how to solve this.

Please Help

Regards
Manoj

[Amicron]

Make sure you have your date format set properly in Windows as well (Control Panel). Even though Access will DISPLAY dates in the format you specify, it will sometimes ACCEPT them however Windows is formatted. Also, if you're still having problems, instead of changing the FORMAT property, set yourself up an INPUT MASK.

Richard Rost
[Links removed]