Break down date range into month identifiers in ACCES 2010
Posted on 2013-12-17
I am getting tired and desperately need help. I have ultimately a report that will span 18 months, can start at any time during the year so, say if the user wants to start the 18-month span on April 15 2013, then Month1 is April, Month2 is May, up to the next 18 months. However, in the data source, for a project I could have to start with is a date range say, Start Date for FTE Assignment = May 20, 2013, End Date for FTE Assignment is September 20, 2014. I need a way to assign May as the Month2 and each month thereafter the next consecutive month number. I have a procedure that use the report start date to determine which months are to be considered as Month1, Month2, etc to Month18, but I need to take the data start and end dates, break it down into the months as assign each month to the correct Month Report number and am at a loss. I thought I would start with a date diff to get the count of the months between May and the end Start date, but then got stuck. I am trying to get staffing needs for various projects over the 18-month span and the projects all start/end on different dates, so need to determine staff needs for the months.
Hope that makes sense.