Skip to Content
0
Former Member
Jan 17, 2005 at 10:57 AM

Handling Calendar Periods

27 Views

Hello Gurus,

I have a client whose calendar period is for 15 months rather than the usual 12 months(Apr to Mar).

for eg:-

1. April 1- April 24 April

2. April 25 - May 24 May

3. May 25 - June 24 June

4. June 25 - June 30 June Q1 end

5. Jul 1 - July 24 July

6. July 25 - Aug 24 Aug

7. Aug 25 - Sep 24 Sep

8. Sep 25 - Sep 31 - Sep Q2 End

9. Sep 1 - Oct 24 Oct Oct

10. Oct 25 - Nov 24 Nov Nov

11. Nov 25 - Dec 24 Dec Dec

12. Dec 25 - Dec 31 Dec Dec Q3 End

13. Jan 1 - Jan 24 Jan Jan

14. Jan 25 - Feb 24 Feb Feb

15. Feb 25 - Mar 31 Mar Mar Q4 End

This is applicable for reports in all modules, if I want to show a break-up of Cal/month.

How do I handle such a situation.

Help is appreciated. Thanks in advance.

regards,

TR PRADEEP