A lot of my data mutilation involves dates and duration around services that a client receives. My issue is that when a client services cross over into different fiscal years. I need to show how many days client received services in each fiscal year.
Example of fiscal year: FY13: 7/1/2012 - 6/30/2013
FY12: 7/1/2011 - 6/30/2012
example of a client date of service: 5/14/2012 - 8/14/2012
Total days of service is 91
I need to break the days of service in FY that was served.
Days in FY12 should be : 47
Days in FY13 should be : 44