I have a project where I need to make a value list of dates based on start date and end date. Once I have a value list I can then select a value position based on other criteria.
A date range on the record may be: (start) 1/1/2014 to 4/15/2014 (end)
The list created and stored in a field or var would always be for the first day of each month for the duration of the date range:
I'd like this to occur as a calc or CF, I'd rather not script this to create a variable because there may be a few hundred needed to generate.
Any comments or advice, approach is welcome.