Classic ASP Discussion - Dates in SQL String

Print Page | Close Window

Dates in SQL String

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=7433
Printed Date: 31 March 2026 at 11:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Dates in SQL String

Posted By: Misty
Subject: Dates in SQL String
Date Posted: 20 November 2003 at 2:27pm

I would like to write a SQL String where it would show only records that are on today's date or later's date. It seems like I remember seeing how you could do this somewhere. But I cannot remember where. I don't want the records with the dates before today to be displayed on the ASP page.

Does anyone know where I can get information on how to write this SQL String?

Replies:

Posted By: MorningZ
Date Posted: 20 November 2003 at 5:48pm

For SQL Server:
SELECT blah1, blah2 WHERE ColDate >= getDate()

For Access:
SELECT blah1, blah2 WHERE ColDate >= Now()

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: Misty
Date Posted: 20 November 2003 at 5:59pm

Thank you! I have it working now.