IN MS ACCESS, THE LONG AND SHORT DATE OPTION DOES NOT SHOW 4 DIGIT YEARS. HOW DO I ACHIEVE THE MM/DD/YYYY FORMAT?

Awadhendra Tiwari

Total Post:510

Points:2550
Posted by  Awadhendra Tiwari
 2815  View(s)
Ratings:
Rate this:
  1. Awadhendra Tiwari

    Post:510

    Points:2550
    In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

    In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!