I have a very strange problem that has completely confused me.
Having used MANY tables dating back to 2003, etc in Access 2007 with NO problems with the 'Date()' function I am experiencing multiple failures in Access 2010.
When I first opened these Tables in 2010 the error message 'Unknown function 'Date' in validation expression or default value on tblXXXX' was shown and the Default Value of today's date did not work.
I have now had to disable the Deafult Value of Date() in these tables.
Interestingly, NOT all of my tables are affected but the majority alas are.
There were NO changes made to the tables, the original WORKING databases were simply opened in 2010 after an upgrade.
Why do I always seem to get such niggles / issues after upgrades?!!
Any ideas?