5 Replies Latest reply: Feb 20, 2013 1:02 PM by user10675696 RSS

    How to get last 3 months on basis of sysdate in prompt

    user10675696
      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