Change database value based on date (ASP)

Question

Hi there,

I have 3 dropdown lists in a form for the user to input the date by day, month and year. How can I make that once t is the date that been input by the user, it will change the status from PUBLISH to UNPUBLISHED in the database?

Below is my codes:

<%cDay=rs_update1.Fields.Item("aDay").Value%> <%cMonth=rs_update1.Fields.Item("aMonth").Value%> <%cYear=rs_update1.Fields.Item("aYear").Value%>

<% Dim theDate : theDate = Now() Dim Result : Result = false if Year(theDate) <= "cYear" then if Month(theDate) <= "cMonth" then if Day(theDate) <= "cDay" then Result = true end if end if end if %>

<%if Result then%> <%theVal=rs_update1.Fields.Item("Status").Value theVal="UNPUBLISHED"%> <%end if%>

Need your help. Thanks.

Answer 1

Why don't you use the DateSerial function to convert the separate values into date values, and use that to compare two dates.

From the page at W3Schools:

The DateSerial function returns a Variant of subtype Date for a specified year, month, and day.

Syntax DateSerial(year,month,day)

Parameter Description year Required. A number between 100 and 9999, or a numeric expression. Values between 0 and 99 are interpreted as the years 1900–1999. For all other year arguments, use a complete four-digit year month Required. Any numeric expression day Required. Any numeric expression

Examples Example 1

document.write(DateSerial(2010,2,3))

The output of the code above will be:

2/3/2010 

Example 2 Subtract 10 days:

document.write(DateSerial(2010,2,3-10))

The output of the code above will be:

1/24/2010