AnsweredAssumed Answered

Creating a Date Value List Function

Question asked by rothdavid on Oct 9, 2014
Latest reply on Oct 9, 2014 by rothdavid

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:

 

1/1/2014

2/1/2014

3/1/2014

4/1/2014

 

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.

 

Thank you,

 

David

Outcomes