Hello
I have a very peculiar error
I am hitting the following error
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 59140] The evaluation of the index 10 expression on row count -1 failed. [nQSError: 46046] Datetime value 2012/04/01 does not match the specified format. (HY000)
This is using the formula
cast ( timestampadd(SQL_TSI_DAY, @{pv_offset}{0}, timestampadd(SQL_TSI_YEAR, -1, Cast(Cast(DATE '@{pv_as_of_date}{2012-04-01}' AS CHAR) AS TIMESTAMP) )) as DATE)
The peculiar thing about this, is that this formula works perfectly in another report, but when I try to implement it into another report it doesnt work.
And in the other report, where it works when I remove all the columns and isolate the column with the formula then the error pops up again.
Is there any additional items I need to set before being able to use the formula above?
What could be happening?
Any insight much appreciate