Forum Discussion
Luuk_Hessing
May 18, 2021Copper Contributor
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...
- May 19, 2021Hello 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.
Luuk_Hessing
May 19, 2021Copper Contributor
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.
George_Hepworth
May 20, 2021Silver Contributor
My apologies. I did not realize you wanted to make this a universal setting throughout all of your accdbs.
- Gustav_BrockMay 20, 2021Iron Contributor
- George_HepworthMay 20, 2021Silver ContributorHmm. That option was grayed out the first time I looked....
- isladogsMay 20, 2021MVPAs it is a client setting, that presumably means individual users can untick it again
Perhaps it would be better to set this using code in order to ensure it applies?