Date Manipulation

pallone · May 4th, 2006, 11:05 AM

Hi,

I have to create a drop down box in javascript (select - options) but the date range will be dictated by an xml document.

<Products>
<Product ID="p6" firsIns="2004-01-01" lastIns="2004-12-31" />
<Product prodID="p5 firsIns="2003-01-01" lastIns="2005-12-31" />
</Products>

So in this case the earlist date is - firsIns="2003-01-01"
and the last date is - lastIns="2005-12-31".

Basically, I have to loop through the xml and find the earliest insertion and last insertion and then populate the drop down list based on the firt and last date.

The select should look something like this:

<select id="selDummyDate1">
<option value="2003.1">Jan 03</option>
<option value="2003.2>feb 03</option>
<option value="2003.3>Mar 03</option>
---------
<option value="2004.1>Jan 04</option>

----------
<option value="2005.12>Dec 05</option>
</select>

I cannot figure out how to populate the select tag with the date range starting from Jan 03 up to Dec 05 (including all months in 2003, 2004 and 2005).

Please note that what dictate the month is the number "01" after the year (2003-01-01) and I will have to change 01 to Jan and so on. I will also have to add the value like value="2003.1" (year.month)

I would appreciate very much if someone could help with the code. Is it possible to do it with JavaScript ??

Cheers

CP

pallone · May 4th, 2006, 04:37 PM

I am sorry if my explanation was not clear. To simplify it this is what I would like help with.

If have two dates like these:

Initial date
2003-01-01

Last date
2005-12-31

How do I create a drop down list with all the month names and years in that range? And the value of the options should have this format for Jan 2003 and so on:

<options value="2003.1">

This is what the drop down should look like:

<select id="selDummyDate1">
  <option value="2003.1">Jan 03</option>
  <option value="2003.2>feb 03</option>
  <option value="2003.3>Mar 03</option>
  --------- and so on
  <option value="2004.1>Jan 04</option>
  ---------- and so on up to Dec 2005
  <option value="2005.12>Dec 05</option>
</select>

I do not know how to calculate the date range and would really appreciate some help.

Cheers,

CP

pallone · May 5th, 2006, 02:15 PM

This is what I have tried to do so far but it is not what I need and I cannot figure out how to do that. I need to start from a predefined date like 2003-01-01
and an end date like 2005-12-31.

Then I need to create a loop that will get all the months and year in the range and create the option for the select tag.

Please could someone help ?

Cheers

<html>
  <head>

    <script type="text/javascript">
        var months = new Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep",
                                "Out", "Nov", "Dec")

        var now = new Date()
        var yy=now.getYear();

        function init()
        {

        var sel = document.getElementById("selDate")
        var theList = sel.options

        for(i=0;i<months.length;i++)
        {
            var n = i+1
            var option = new Option(months[i]+" "+yy , yy+"."+n)
            theList[i] = option

        }
        alert(theList.innerHTML)
        }

    </script>

  </head>
  <body onload="init()">

    <form id="Form1" method="post">
    <select id="selDate">

    </select>

     </form>

  </body>
</html>