error Invalid parameter 1 specified for datediff. when running reports

cadwyn posted on 12-21-2009 6:18 AM

rated by 0 users

Hi - from the Admin - Reports menu if I select either of:

"Open Problems Aging" Report
"Time" Report

I get this error message:

Application Error
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for SQL Server
Description: Invalid parameter 1 specified for datediff.
--------------------------------------------------------------------------------
The SQL query string is using bad syntax. Read the description above and check the code. 

 Does anyone else get this problem?  Any idea what might cause it?

I'm using the uk date mod, I don't know if that could make any difference?