Hi John,
Here's a Custom Function to generate the return-separated list of all
the month names between a start and end date, including the starting
month and ending month:
MonthList ( dateStart ; dateEnd ) =
-----------------
Let (
[
m = Month ( dateStart ) ;
y = Year ( dateStart ) ;
start = Date ( m ; 1 ; y ) ;
end = Date ( Month ( dateEnd ) ; 1 ; Year ( dateEnd ) )
] ;
If (
start ≤ end ;
MonthName ( start ) & " " & ¶ &
MonthList ( Date ( m+1 ; 1 ; y ) ; end )
)
)
Regards,
Chad
On Jun 5, 2007, at 9:07 AM, John Wenmeekers wrote:
Hi Nick,
if I go with a CF, which has my preference, it could be a ¶
separated list.
From that point on I can go in whatever direction I want/need.
I'm still at the 'thinking' level.
If the result is in a ¶ list, I could use the Filtervalues()
function, compare with
a list of months and get the result.
But that is still one step to far in the process where I'm now.
First the months out of the range.
So...a ¶ list would be the most appropriate format.
Thanks
***************
Chad Novotny
Vice President - Technology
The Support Group, Inc.
database design, development and training services
boston - los angeles - new york - san francisco
24 Prime Park Way
Natick, MA 01760
t: 508.653.8400 x217
f: 508.653.2830
[EMAIL PROTECTED]
www.supportgroup.com
