Hi there...I am creating a drop-down with years. Now I need to display 10 years starting from this year so 2007, 2008, 2009...2017. So next year the drop down will show 2008, 2009,....2018...I think year(Date+1) is pretty stupid to try...but I did and offcourse it doesnt work)

<select name=ExpirationYear class=fields>

<option></option>
<option value="Sign In"><%=Year(Date) %></option>
<option value="Sign In From Unpaid break"><%=Year(Date+1) %></option>
<option value="Sign Out For Unpaid break">2009</option>
<option value="Sign Out">2010</option>
<option value="Sign In">2011</option>
<option value="Sign In From Unpaid break">2012</option>
<option value="Sign Out For Unpaid break">2013</option>
<option value="Sign Out">2014</option>
<option value="Sign In">2015</option>
<option value="Sign In From Unpaid break">2016</option>
<option value="Sign Out For Unpaid break">2017</option>
<option value="Sign Out">2018</option>

</select>

Any clues???

Hey there...sorry for posting too soon...looks like i got the answer...silly me...its <%=Year(Date)+2%>

Hi,

You can also use the DateAdd function, I know you have already solved the problem. But its a function worth nowing.

http://www.w3schools.com/vbscript/func_dateadd.asp

My suggestion is write a function which can accept two parameters StartYear & EndYear and generate a dropdown. Use DateAdd function. This would be more flexible.

First off, while your solution is "correct", it's not the optimal. Try to use ASP functions as minimally as you can as every call to a built-in function does take up some server resource.

Do something like this instead:

Dim Start_Year, End_Year, i
Start_Year = Year (Date)
End_Year = Start_Year + 10
for i = Start_Year to End_Year
     Response.Write "<option>" & i & "</option>"
Next

One call to retrieve the year, one call to retrieve the date, no other functions necessary.