In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?
Ans) In the date field properties of the table, form, or properties actually input the format you would like. It is not needed to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.