comparing dates

benbacardi · #1 Aug 27th, 2004, 20:05

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

if thisdate < today
....

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

Rob · #2 Aug 27th, 2004, 21:11

use this:-

Code: Select all

if (cdate(thisdate)) < now()

The cDate function, converts a string to a date.

benbacardi · #3 Aug 28th, 2004, 09:57

ok thanks...

benbacardi · #4 Aug 28th, 2004, 12:39

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 · #5 Aug 29th, 2004, 08:49

remove this from your code:-

Code: Select all

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

... or put it after the cdate line.

benbacardi · #6 Aug 29th, 2004, 09:23

thanks rob, it worked a treat

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP dates	simonb	PHP Forum	11	Sep 5th, 2007 14:30
Comparing two large XML files	joeandersen	Other Programming Languages	1	Jul 28th, 2006 07:21
GROUP BY and dates in SQL (again)	spinal007	Databases	4	Dec 13th, 2004 17:26
dates in SQL	spinal007	Databases	3	Nov 10th, 2004 09:32
dates	benbacardi	Classic ASP	2	Sep 14th, 2004 16:18

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
comparing dates