I have several make table queries that use the DatePart function to limit the resulting table. Today all these queries fail with the error message "Invalid procedure call". The query looks like this:
Field name is YratePart("yyyy",[ReqShipDate])
Criteria is DatePart("yyyy",Date())
When it was working it returned all the records where the year in the ReqShipDate field is the current year. If I change it so that the field is [ReqShipDate] and the criteria is >=#01/01/19# and <#01/01/20# it works fine, but then I need to edit all the queries every year on January 1.
Any thoughts on why this function suddenly stopped working?