Calculate months

Have you thought of using a combo box to select the first month only and then fill in the next 11 text fields with the appropriate month?

There are some interesting things that can be done with the date object and the 'util.printd()' method.

George, that's not what he wants to achieve, I think. He want the text fields to be filled with the months between the first one and the second one. However, I do think that using combo-boxes would make it easier to implement. I might post some code later on.

OK, so I'm assuming the following:
- You have two combo-boxes ("Month1" and "Month2") with the months as values and 1 through 12 as export values.
- You have a set of 12 text fields named "MonthText1" to "MonthText12".

You can then use this script to populate your text boxes:

month1 = this.getField("Month1").value;
month2 = this.getField("Month2").value;

if (month1!="" && month2!="") {
if (month1>month2) {
var index = 1;
for (i=month1; i<=12; i++) {
date1 = util.scand("dd/mm/yyyy", "01/" + i + "/" + new Date().getFullYear());
this.getField("MonthText"+index).value = util.printd("mmmm", date1);
index++;
}for (i=1; i<=month2; i++) {
date1 = util.scand("dd/mm/yyyy", "01/" + i + "/" + (new Date().getFullYear()+1));
this.getField("MonthText"+index).value = util.printd("mmmm", date1);
index++;
}} else {
var index = 1;
for (i=month1; i<=month2; i++) {
date1 = util.scand("dd/mm/yyyy", "01/" + i + "/" + new Date().getFullYear());
this.getField("MonthText"+index).value = util.printd("mmmm", date1);
index++;
}
}
} else {
for (i=1; i<=12; i++) {
this.getField("MonthText"+index).value = "";
}
}

Thanks try67,

This works well. Just a couple of things...

1) If the range is less than 12 months from Month1 to Month2, then the remaining months are unchanged from the previous month inputs.

2) Is it possible to put some formula in there to only populate the months in the range? For example, if it is from October 2010 to February 2011, I would like for the MonthText fields to populate only 5 months (October, November, December, January, February) and the rest of the MonthText fields to be blank.

If it helps, there are two other fields available: Year1 and Year2 that coincide with Month1 and Month2.

Thanks so much!