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