Forum Discussion
Formatting 2-digit year in MS Access. How?
- 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".
Gustav_Brock I don't know if this will be seen or not. I did a Google search for this very subject and came across this thread. The problem that I'm facing is that the boxes for four-digit year formatting are ALREADY UNCHECKED. However, my database continues to apply four-digit years to some of my fields. Not all of them, but only some of them. I would very much prefer a two-digit year, but ultimately I want consistency and for some reason it is giving me four digits for birth years in the 1930's and 1940's and two digits for all birth years since 1950. Any ideas why?
Access assumes that two-digit years before 50 belong to 2000 while those 50 and after belong to 1900:
? DateValue("49-01-01") 2049-01-01 ? DateValue("50-01-01") 1950-01-01
- 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.- My apologies. I did not realize you wanted to make this a universal setting throughout all of your accdbs.
- Great! Then please mark as "best response" to serve future readers.
