Hello, I have a crystal report that tracks equipment downtime/availability. The report selects records for the past year and sorts them by month, I need to calculate the monthly downtime hours and equipment availability for each piece of equipment. Works fine when the start date and end date are in the same month. If the end date spans 1 or more months I have calculated the hours for that month in which the recored started. But how do I account for the hours in the next month (s). ie
In the above WO#1 is started and ends in the same month - no problem
WO#2 starts in Jul but ends in Sep, I've calculated the hours to the end of Jul but what about the hours in Aug and Sep.
Can I have the WO show up in different months if the end date spans more than one month. or how would I account for the hours in Aug and Sep?
Any suggestion appriciated.