I think the first option (month names as a comma separated list) would be best done as a recursive custom function:
MonthList ( datestart ; dateend ) =
sm = Month ( datestart );
em = Month ( dateend );
em = em + If ( em < sm; 12 )
If ( sm ≠ em;
MonthName ( datestart ) & ", " & MonthList ( Date ( sm+1; 1; Year ( datestart ) ) ; dateend ) ;
MonthName ( datestart )
The second option is easier as a standard calculation:
Left ( MonthName ( start date ); 3 ) &
If ( Month ( start date ) ≠ Month ( end date ) ; " - " & Left ( MonthName ( end date ); 3) ; "" )
Hope that helps.
Thanks David ... Will try it out
Why is your reply marked as the correct answer?
sorry , thats a mistake ...