So not sure why this is but the linked SQL Views NOT refreshed still works with the Date format ####-##-##.
I believe it used to be ##/##/#### as the data formula / criteria such as Month(Date) or DateSerial or DatePart worked but now it doesn't only after refreshing the links.
I think they have changed the date format on the SQL tables. I'm seeing the ####-##-## in the SQL View results.
Strange thing is another Access file linked to the same SQL Views still works but AFTER refreshing them in another database it does not.
Any ideas / suggestions?