comparing dates

[benbacardi]

how can i see if one date (thisdate) is before or after todays date (today)? can i use:

Code: Select all

if thisdate < today
....

and if so, which way round do i have to put the < for if thisdate is before today?

[Rob]

use this:-

Code: Select all

if (cdate(thisdate)) < now()

The cDate function, converts a string to a date.

[benbacardi]

ok thanks...

[benbacardi]

ok i get an error now...

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'cdate'
/ss/calendarhome.asp, line 226

but this is my code (RSgetall is a record set of the records in a database, edate is a text field with a date in it (in mm/dd/yy format)):

Code: Select all

thisdate = formatdatetime(RSgetall("edate").value,vbLongDate)
if (cdate(thisdate)) < Now() Then

'code in here

End if

[Rob]

remove this from your code:-

Code: Select all

thisdate = formatdatetime(RSgetall("edate").value,vbLongDate)

... or put it after the cdate line.

[benbacardi]

thanks rob, it worked a treat