By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,572 Members | 2,949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,572 IT Pros & Developers. It's quick & easy.

Problem With Dates

P: 48
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

Sep 15 '07 #1
Share this Question
Share on Google+
1 Reply

P: 2
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]
Sep 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.