Fiscal Period Conversion Problem

[RobMcP]

Hi all,

I currently have a date of notification in a cross-tab report from which I am extracting the calendar year. I now need to change this year from calendar to our fiscal year. (which runs from 1st July to 30th June). So in effect if notification occurred on 30th June 2005 it would be in the period 04 – 05 and if notification occurred on the 1st July 2005 it would be in the period 05 – 06.

My Cross-Tab currently looks like this:

		        Policy Year
Year of Processing	1997	1998	1999	2000	
2003	               29	  0        0	  15	  
2004	                0	  1	    4	  17	   
2005		            0      0        1 	  5	   
2006		            0      0        0 	  1

I’m completely stumped on this and would appreciate any assistance you can give. I am using Crystal 10

Thanks in advance, Rob

 

[lbass]

I think you could use a formula like:

year({table.date}+184)

...as your row field. Or use a formula:

{table.date}+184

...and then to go to group options->print on change of year.

-LB