Date variables...

neo_jakey · January 15th, 2004, 10:10 AM

Hi All,
I am trying to utilize a date stored in the database and then compare it within a dropdown menu so that date will be specified. I have used the following command to split the date:

rsDate = oRSbt("DueDate")
DateArray = Split(rsDate,"/")

I am then using the part in the array to make up the date in three drop down boxes. I have successfully done the day and month but I am have terrible trouble with the year. I am using the following code:

<% BeginYear = Application("PAST_YEAR")
CurrentYear = Application("CURRENT_YEAR")
EndYear = Application("NEXT_YEAR") %>

<select name="rsYear" class="f" tabindex="7">
<option value="<%=BeginYear%>"<% if DateArray(2) = BeginYear then Response.Write(" selected") end if %>><%=BeginYear%></option>
<option value="<%=CurrentYear%>"<% if DateArray(2) = CurrentYear then Response.Write(" selected") end if %>><%=CurrentYear%></option>
<option value="<%=EndYear%>"<% if DateArray(2) = EndYear then Response.Write(" selected") end if %>><%=EndYear%></option>
</select>

However with this code the current year does not get selected in the drop down box...

Any ideas anyone

With many thanks for your time and assistance,

Paul J

jb3 · January 15th, 2004, 02:36 PM

The reason this is not working is that this code results in a common error with undeclared variable types. ASP is getting the value from the selector and it assigns it to a variant as type string, while your datearray value is probably a variant of type integer or some numeric type. When you 'test' them using If then - they will never be equal, hence you do not get what you expect...

Below is the sample page I created to verify this for you - save it as "test.asp" in your local web and then uncomment/comment the two lines for DateArray - to see how the page reacts.

Regards
John

<%
'DateArray = request.form("rsYear")
DateArray = cint(request.form("rsYear"))

'BeginYear = Application("PAST_YEAR")
'CurrentYear = Application("CURRENT_YEAR")
'EndYear = Application("NEXT_YEAR")

BeginYear = 2003
CurrentYear = 2004
EndYear = 2005

%>

<html>
<body>

<form name="frmForm" method="post" action="test.asp">

<select name="rsYear"tabindex="7" OnChange="submit()">
  <option value="<%=BeginYear%>"<% if DateArray = BeginYear then Response.Write(" selected") end if %>><%=BeginYear%></option>
  <option value="<%=CurrentYear%>"<% if DateArray = CurrentYear then Response.Write(" selected") end if %>><%=CurrentYear%></option>
  <option value="<%=EndYear%>"<% if DateArray = EndYear then Response.Write(" selected") end if %>><%=EndYear%></option>
</select>

</form>
</body>
</html>