CODEWITHSUNDEEP
dateasp-classicvbscript
poo
poo

Reputation: 1115

How can I compare two dates in vbscript/ASP?

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

Upvotes: 18

Views: 69240

Answers (2)

Mikos
Mikos

Reputation: 8563

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

Upvotes: 25

Welbog
Welbog

Reputation: 60458

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().

Upvotes: 18

Related Questions