Forum Discussion
Access 2019 Short-Date Format
I had changed the short date in Regional settings to include the 3-digit day-of-week. This was so I could see the day-of-week on the taskbar calendar.
After changing this back to mm/dd/yy for the short-date, the Access short date was corrected. I also noticed Excel dates were incorrect (but now corrected).
I guess I shot myself in the foot
. Thank you muchly for your suggestion. I would not have tied Region information to Access or Excel. But, I guess w10 is also Microsoft.
I had changed the short date in Regional settings to include the 3-digit day-of-week. This was so I could see the day-of-week on the taskbar calendar.
After changing this back to mm/dd/yy for the short-date, the Access short date was corrected. I also noticed Excel dates were incorrect (but now corrected).
I guess I shot myself in the foot . Thank you muchly for your suggestion. I would not have tied Region information to Access or Excel. But, I guess w10 is also Microsoft.
neil-wilson I know what you mean, but due to a recent event involving the release of the new Northwind Showcase templates, regional settings are very much top of mind this week. Lucky coincidence, you might say.