Show Records until a Certain date : Active Server Pages (ASP)

This short tutorial will show you how to use a quick WHERE statement to filter your records so it only shows whilst the date column in the table is either greater or equal to the current day.

Prerequisites

Knowledge of using ASP pages For Dreamweaver uses you will need to feel comfortable using the Advanced view of a Recordset.

Obviously you will knowledge of using either Access or SQL server as your database.

Details

Create your Recordset as normal.

For the WHERE statement, use the below text, to show your records whilst the date column is greater or equal then the current day.

Change table to your table name and column to the column which contains your records date.

Using Access

WHERE (((table.column)>=Date()))

Using SQL server 2000

WHERE (((table.Column)>=getdate()))

If you are using Dreamweaver MX, you will need to change the Recordset to the Advanced view, and alter the WHERE statement to the text above.