How to get last 3 months on basis of sysdate in prompt
Hi,
I am using Fiscal Month in the prompts and the data in the column looks like below
201201
201202
201203
201204
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)
Rgds,
Ma