Prev: Report Models error - No IdentifyingAttributes
Next: Help!!! - Subscriptions won't run; here is the LOG file
From: bjkaledas on 18 May 2007 07:56 Hi, I encountered a strange error today. I have an Integer parameter "hours" that I am trying to use in my SQL Query. DATEADD(hh, @hours, @startTime) It works if I have it set such as DATEADD(hh, 8, @startTime), but I need that parameter there for what I need. I get this error: Error Source: System.Data Error Message: Failed to convert parameter value from Decimal to DateTime. I tried a variety of CInt and other conversion functions to no avail. Any ideas? |