Im at my wits end for this
I have a report where I am using a filter with a simple SQL expression
cast ( timestampadd(SQL_TSI_YEAR, -1, Cast(Cast(DATE '@{pv_as_of_date}{2013-04-01}' AS CHAR) AS TIMESTAMP) ) as DATE)
So an end user may input a date and this is passed into the filter via a variable
pv_as_of_date
This is defaulted to 2013-04-01
I want to subtract 1 year to make the end result
2012-04-01
When I run the report I am seeing two issues
1) When displaying the filter at the bottom, I see the full SQL code. Shouldnt this show the date returned? In this case shouldnt the filter show 2012-04-01?
2) The filter does not even work which is my bigger problem
I tested the above code in a column and I KNOW that the date is being returned as expected
But when I use the same SQL code in the filter then it doesnt work
Am I missing some special button some where to enable SQL expressions?
Any help immensely appreciated