Skip to Content
0
Former Member
Oct 08, 2014 at 07:49 PM

Need formula to show correct date range in Crosstab report

13 Views

I need to create a formula to show the correct date range in a crosstab report. For example, if the user enters start period MM=10 start year YY=2013 and End period MM=04 and End year is 2014. The Crosstab will return months 10-12 for 2013, 01-04 for 2014, plus 01-04 for 2013 as well. What is desired is just months OCT.2013-Dec 2013 and then Jan-April 2014 and that is all. See screenshot below:

Any help would be greatly appreciated.

Edmund

Attachments

CrossTabs1.png (203.3 kB)