Translating month number to name

HCL Domino Domino Forum
1

I have two dates - project start date and project end date. I need a drop down of all the monthes between these 2 dates - so if your dates were 6/5/04 and 10/25/04 the drop down would show June, July, August, September, October. I need to do this through a view - so I have gotten as far as producing a list of 6, 7, 8, 9, 10, but I would like June, July, August, September, October to be displayed. I have tried @Select(@TextToNumber(MonthList);“January”;“February”;“March”;“April”;“May”;“June”;“July”;“August”;“September”;“October”;“November”;“December”) BUT it only displays the first month (june).Any help would be appreciated!

Thanks

2

Subject: the answer :slight_smile:

@If( StartDate > EndDate; @Return(“”); “” );y := @If( @Year(StartDate) = @Year(EndDate); @False; @True );

d := @Date( @Year(StartDate); @Month(StartDate); 1 );

m := “January February March April May June July August September October November December”;

r := “”;

@While(d <= EndDate; r := r : ( @Word(m; " "; @Month(d)) + @If(y; " " + @Text(@Year(d)); “”) ); d := @Adjust(d; 0; 1; 0; 0; 0; 0) );

@Trim(r)

3

Subject: Translating month number to name

if you can use LS…it can be easily done…The @Select(number,list) the number paarmeter in the @Select must be a single value and not a list and thats why it always gives you the first value…June.

You would have to loop through all the values in the monthList to get these values…as I said can be done easily in Script.

4

Subject: Try:

MList := “January” : “February” : “March” : “April” : “May” : “June” : “July” : “August” : “September” : “October” : “November” : “December”;NList := “1” : “2” : “3” : “4” : “5” : “6” : “7” : “8” : “9” : “10” : “11” : “12”;

@Replace(MonthList; NList; MList)

5

Subject: Another solution

Try this:I suggest to use this formula in a computed text (only for display)

REM “declare the date field”;

FIELD date := date;

@If (date != “”;@Success;@Return(" "));

month:=@Select(@Month(date);“-ENE-”;“-FEB-”;“-MAR-”;“-ABR-”;“-MAY-”;

“-JUN-”;“-JUL-”;“-AGO-”;“-SEP-”;“-OCT-”;“-NOV-”;“-DIC-”);

day:=@Text(@Day(FechaVig));

year:=@Text(@Year(FechaVig));

day + month + year

6

Subject: This 3-line formula works

(Given the normal caveats of testing for empty date fields and setting "Refresh choices on document refresh…)

molist := “Jan” : “Feb” : “Mar” : “Apr” : “May” : “Jun” : “Jul” : “Aug” : “Sep” : “Oct” : “Nov” : “Dec”;

endmo := @month(EndDate);

@subset(@subset(molist; endmo); @month(StartDate) - endmo - 1)