Back to Top
The nuts and bolts for
Creative web development

Display Records until a Certain date

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

Carl Grint

Carl Grint" Since graduating from university, I have worked with Charities and the Public sector, with my longest time being 3 years with the NHS until returning to freelance in 2003.

I would like to think my diverse experience of working for both the Public and Private sector gives me a good all rounding which enables me to approach projects with a unique perspective and enables me to bring new thoughts and initiatives to my work.

I have always enjoyed passing on the lessons I have learned so other developers can bypass the 'working out' time I had to go through, and writing my first two articles for DMXzone has given me a chance to pass on what I think are some good ways to improve on the standard Authentication behaviours Macromedia supply with Dreamweaver."

See All Postings From Carl Grint >>

Share this Article