View Single Post
  #1  
Old 29th July 2019, 10:02
MW Giles MW Giles is offline
Senior Member
 
Join Date: Dec 2010
Location: Worcestershire
Posts: 704
MW Giles is on a distinguished road
MS Access and dates

Just a warning, overnight with the latest upgrade to MS Access it decided that all the dates in my database had to be long 02/02/1945 rather than just medium 02/02/45 format

This has thrown all my formatting to ???<<<***!

I knew it was coming as we are very nearly within 20 years of 1st September 2039, it was the fact that it did it all without asking that has annoyed me.

Just have to spend a few days reformatting everything and getting used to typing the century in when I make a query

Regards

Martin
Reply With Quote