SQL Sate - elimate post-dates

[tyleri]

I want the asp code to only display dates including the current date and any future dates. how can I eliminate any expired dates?

here is what i have to work with now:

Set rstSimple = cnnSimple.Execute("SELECT * FROM shows&quot

 

[rac2]

Dim dateToday
dateToday = Date
Set rstSimple = cnnSimple.Execute("SELECT * FROM shows WHERE date >=" & dateToday )

Depending on the database you may need to convert dateToday to a string and add quote marks or # around the string.

. . . WHERE date >=#" & CStr(dateToday) & "#" . . .
or
. . . WHERE date >='" & CStr(dateToday) & "'" . . .