I know this subject has been covered pretty extensively but my search has not uncovered the info I am looking for.
I have a StartDate, an EndDate, and a Status per record what I need is to be able to pull a report by month for each status.
March Report
Status 1 3hrs 2min
Status 2 6hrs 9min
My problem is that my Start and End dates may span multiple months like start March 5th 12:00 and end April 12 09:10 When this happens I need the March portion in March and the april portion in April
Any help is greatly appreciated
Thanks, Frank
I have a StartDate, an EndDate, and a Status per record what I need is to be able to pull a report by month for each status.
March Report
Status 1 3hrs 2min
Status 2 6hrs 9min
My problem is that my Start and End dates may span multiple months like start March 5th 12:00 and end April 12 09:10 When this happens I need the March portion in March and the april portion in April
Any help is greatly appreciated
Thanks, Frank