I have date range report in MS Access that stopped working today. The database is MSSQL 2008 R2, and on my local machine I have a backup copy from March 2015.
The weird thing is if I run a date range between Feb 8 to Feb 14 against my March 2015 copy it works, but it does not work if I run it against today's copy. What could it be?
The error I am getting is 3464 -Data type mismatch in criteria expression