"Invalid Procedure Call" error using DateDiff

J

Jeff

I'm using the DateDiff function in a query and it works
fine until I try to set a filter to only show the records
where the difference <>0. When I add <>0 to the criteria
line and run the query it looks like it is going to work
(I can see the query return the results) but within a
couple of seconds an "Invalid Procedure Call" error pops
up and all my data changes to #Name?. Can anyone tell me
what is going on? Thanks,

Jeff
 
K

Ken Snell [MVP]

Any chance that either of the fields being used as "start date" or "end
date" contain Null values?
 
J

Jeff

Ken,

In looking to find if any of the values were null, I found
that there was a date that did not convert properly (it
was wrong in my source file - year 1885 instead of 1985)
So after fixing that it worked fine. Thanks.

Jeff
 
Top