How can I compare two dates in vbscript/ASP?

user_269559 0
Viewed 62544

Using ASP classic, I need to somehow compare two dates with each other. How can I do this?

asp-classic vbscript date
2 Answers
Date1 = #rs["date"]#
Date2 = #12/1/2009#


If DateDiff("d", Date1, Date2) > 1 Then
    response.write "This date is before 12/1/2009"
Else
    response.write "This date is after 12/1/2009"
End If
user_2728610 
If Date1 > Date2 Then
  ' Date1 occurred after Date 2
End If

Use >, < and = like comparing numbers (and >=, <= and <> too). Smaller dates are more historic.

This of course assumes that Date1 and Date2 are actually Date or DateTime objects. If they aren't, you'll need to convert them to Date objects first using CDate().

Welbog_524430
Related