I am using CR XI
I would like to find the simplest way to get a monthly total days within a year's span
For Example
I would like to get the total number of days in January 2014 between the Begin Date and End Date
Begin Date End Date
12-9-13 -- 7-22-14 (need to show 31 days for this example)
1-8-14 -- 8-15-14 (need to show 23 days for this example)
1-15-14 -- 1-20-14 (need to show 5 days for this example)
1-28-14 (End Date is null, need to show 3 days for this example)
I could write a formula for each month of the year, but is there an easier way using a Running Total?
I would like to find the simplest way to get a monthly total days within a year's span
For Example
I would like to get the total number of days in January 2014 between the Begin Date and End Date
Begin Date End Date
12-9-13 -- 7-22-14 (need to show 31 days for this example)
1-8-14 -- 8-15-14 (need to show 23 days for this example)
1-15-14 -- 1-20-14 (need to show 5 days for this example)
1-28-14 (End Date is null, need to show 3 days for this example)
I could write a formula for each month of the year, but is there an easier way using a Running Total?