DatePart in query causes error message

[cebrower]

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?

[pbaldy]

Are there any Null values in the date field? I don't like that method as it requires the function to be applied to every record in the table. Try a criteria of this directly on the date field:

Between DateSerial(Year(Date()), 1, 1) And DateSerial(Year(Date()), 31, 12)

[cebrower]

Your suggestion works fine - thanks. I still don't understand why the DatePart thing throws an error. There are no nulls in the table and it has worked for years until this morning. Anyhow, thanks again.

[pbaldy]

Happy to help. I'm not sure either, but the new way is more efficient anyway.