ok. this is for the shows section of my bands site. i want to be able to add shows, and then on the main page the users will only be able to see shows that have not occured.
this is what i have so far
showsSQL = "SELECT TOP 4 * FROM events WHERE full_date >= " & Date & " ORDER BY full_date;"
full_date is a variable that is made up of 3 different things. those three things are the month, day, and year inputs that the user puts in.
the problem is, is that shows that have already happened still show up. you can see it at www.dinkumrocks.com/home.asp
thanks for any help
-Naaman