Skip to Content
0
Former Member
Sep 19, 2014 at 02:31 PM

Display three prior months starting from current month

27 Views

Hello All,

I came across the requiremnt:

The report looks like:

2014-Jan 2014-Feb 2014-Mar 2014-Apr 2014-May 2014-June 2014-July 2014-Aug 2014-Sep 2014-oct 2014-Nov 2014-Dec A 122 233 233 233 233 233 233 233 233 233 233 233 B 22 33 33 33 33 33 33 33 33 33 33 33 C 33 33 33 33 33 33 33 33 33 33 33 33 D 333 3333 3333 3333 3333 3333 3333 3333 3333 3333 3333 3333

The requirement is to display the prior 3 months ,current month, next 3 months.

Assume that current month is SEPTEMBER, the report should look like:

2014-June 2014-July 2014-Aug 2014-Sep 2014-oct 2014-Nov 2014-Dec A 233 233 233 233 233 233 233 B 33 33 33 33 33 33 33 C 33 33 33 33 33 33 33 D 3333 3333 3333 3333 3333 3333 3333

Share your thoughts.

Thanks