For ex: if the report month is March 2012,Hi,
A 30 day report will pull data with an end date of 04/30/2012
921698 wrote:1) Build a prompt to return values as "30 days", "60 days" and "90 days". Save them in a pres variable. e.g. date_range.
Yes, it's the one month data. I just gave it as an example. Do not take it as it is!
Another example: if the report month is say, October 2011, then,
1. A 30 day report will pull all data with an end date of 11/30/2011,
2. A 60 day report will pull all data with an end date of 12/31/2011,
3. 90 day report will pull all data with an end date of 12/31/2011.
But it's giving me 'ORA 932' error. Inconsistent datatype:expected DATE got CHAR.In the prompt don't use your date column. Use some varchar column. the formula should be,