SQL error
Hi Champs,
Im building a combined analysis report in which i use a dashboard prompt to calculate the last 12 months in a presentation variable. I pass this value to the criteria reports. But i get the following error.
View Display Error
I have type casted the columns properly but not sure why this message is coming.
Im building a combined analysis report in which i use a dashboard prompt to calculate the last 12 months in a presentation variable. I pass this value to the criteria reports. But i get the following error.
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 46047] Datetime value @{Month12}{2012-07-31} from @{Month12}{2012-07-31} does not match the specified format. (HY000)
I have type casted the columns properly but not sure why this message is coming.
0