Access Date Format using Dot or Period as Separator
Posted on 2013-11-21
We have Office 2010. In Access 2010, I have a table named Docket. In this table I have a field called DktDate.
The field DktDate is formatted as a Short Date. I created a Form named frmDocket.
When I enter dates into the DktDate field of this form...
I can type 11/21/2013 and it displays as 11/21/2013 - This is perfect.
I can type 11/21/13 and it displays as 11/21/2013 - This is perfect.
I can type 11.21.2013 and it displays as 11/21/2013 - This is perfect.
I can type 11.21.13 and it displays as 12/30/1899 - This is a major issue!
I need my users to also be able to type 11.21.13 and I need it to display 11/21/2013.
Can anyone assist me with this?
Also, I don't want to have to alter my settings under the Windows Regional and Language Options.
Thanks in advance!