Linking a set date to a specific time range
I spend the last 2 days trying to dynamically linked a specific date (specified by a user)
I created a module to have visible the versions, country and initiatives (as my lists) and of course the line cost items and calculate the monthly charge per cost line item per costing type based on the elapse time between start and end dates
One of the line items is start date (there is an End Date as well but i think it will be resolved as for the Start Date). The monthly cost items has to be linked to the dates
This is part of an "input sheet"
Then to assign the cost to time, I created another Module. This one will assign the monthly costs to time based on the versions, country and initiatives.
The idea to determine the monthly cost per cost type and per cost item and the first occurrence on the time line has to correspond with the start date on the input sheet and of course the last occurrence the end date.
Now – the problem statement:
My plan was to use the start date and end date to assign start and end dates to determine start and end time periods.
I have tried numerous options without success: