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. 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