I can't find the answer to this problem after extensive searching the web.
I am trying to update a module to add extra functionality to cater for GDPR.
I have added:
strSQL = "SELECT * FROM [" & tblName2 & "] WHERE PROCESSDAY<=DateAdd("yyyy",-5,Date())"
and get a Compile error Expected: end of statement with the yyyy highlighted. Any ideas?
Thanks