Forum Discussion
Solved
Formatting 2-digit year in MS Access. How?
I need a 2-digit year notation and a 2-digit month notation from a date field. Using the helppage of Ms Access the 2-digit month notation wasn't much of a problem after "mm" behind notation and usin...
- Hello Gustav,
And that was the way to do it. The option you referred to, I didn't realize that it was existing. Thank you very much.
Regards from the Netherlands.
Go to menu Files, then Settings, select Client Settings, scroll down to section General, and uncheck marks for "Use four-digit formatting of years".
Hello Gustav,
And that was the way to do it. The option you referred to, I didn't realize that it was existing. Thank you very much.
Regards from the Netherlands.
And that was the way to do it. The option you referred to, I didn't realize that it was existing. Thank you very much.
Regards from the Netherlands.
- My apologies. I did not realize you wanted to make this a universal setting throughout all of your accdbs.
- Hmm. That option was grayed out the first time I looked....
- Great! Then please mark as "best response" to serve future readers.
