i have a list box shows future working days that retrieved from database. Since the date format originally in MDY, so i change it to DMY before i place it to the list box. However, it doesn't work as i expected, it only shows "X" in the list box but not the value of X.
What can I do?
The code is listed as follows:-
<%SQLQUERY = "SELECT * from ehkholiday where datediff(dd,getdate(),date) between 0 and 30"
set RSTitleList = myConnection.Execute(SQLQuery)%>
<td><select NAME="DATE" size="1">
Dim DMY (31)
I = 0
<% Do While not RSTitleList.eof%>
DMY(I) = (<%=RStitleList("date")%>)
I = I + 1
I = 0
Do while i <= 30
I = I+1