I am using Fiscal Month in the prompts and the data in the column looks like below
User will select the prompts between months period, like below
Between 201201 and 201204.
My requirement is, I need to default this Fiscal month value to last 3 months, Since we are in February, it should look like this.
Between 201211 and 201301 (which is last 3 months)
That should be something like
SELECT MONTH FROM "Service - CRM Service Requests" WHERE Time.Date BETWEEN TIMESTAMPADD(SQL_TSI_MONTH,-3, current_date) AND TIMESTAMPADD(SQL_TSI_MONTH,-1, current_date) ORDER BY saw_0
So in each filed you have to put
Hope this helps, update back
Edited by: Srini VEERAVALLI on Feb 20, 2013 12:37 PM