Hi,

I am trying to select a number of records and filter them by the current date in ASP but Im not having any luck.

rsDiary.Source = "SELECT * FROM tblEvents WHERE DateOn > " & Date & " ORDER BY DateOn ASC"

It still however shows the records from last year also.

Any help would be greatly appreciated <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Maybe this is helpful to you:
www.tacoma.washington.edu/at/training/handouts/access/Queries.PDF

Martha Graham

Try:

rsDiary.Source = "SELECT * FROM tblEvents WHERE DateOn &gt;= #" & Date() & "# ORDER BY DateOn ASC"

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

thanks, When using the # method it shows no records at all then.

Im still downloading acrobat reader.