Classic ASP Discussion - compare date

Print Page | Close Window

compare date

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10359
Printed Date: 31 March 2026 at 4:31pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: compare date

Posted By: kobubu
Subject: compare date
Date Posted: 09 May 2004 at 6:26am

hello every one!

im writing a condition if else,there i need to compare a date that is in a table of access to the date today, if the date tody is bigger from the date that i have in the table then.

today> date table

how do i do it ?

thanks ahead.

Replies:

Posted By: Mart
Date Posted: 09 May 2004 at 6:55am

If Now() > rs("whatever") Then

End If

Posted By: kobubu
Date Posted: 09 May 2004 at 7:52am

first thank you for the fast replay

the point is that i have the time now and the time that i have in my table comes with the hours

im writing an auction there i need to verifay if the actual date is greater then the the enddate

thanks ahead

Posted By: Mart
Date Posted: 09 May 2004 at 8:58am

To get the current time you use Now() and get the date from the database into a variable called enddate let's say... then you go

If Now() > enddate Then

'The current time is greater than enddate

End If

Posted By: kobubu
Date Posted: 09 May 2004 at 9:01am

thanks you were very helpful