Fiscal year formula

Crystal 11, I understand grouping dates via traditional calendar ranges but how do you create a formula that groups 10 years of monthly data into our Fiscal year grouping which is September 1 to August 31?



if you create a year(field) formula

than create a group from that iit should group by the year.

you will need to try it, the data im working with i cant test it for you

0 View this answer in context