# Spl date problem?

**URL:** <https://forum.kirupa.com/t/spl-date-problem/144531>\
**Category:** Uncategorized\
**Created:** [April 14, 2005, 11:55pm UTC](https://forum.kirupa.com/t/spl-date-problem/144531 "2005-04-14T23:55:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![imported\_dinkumrocks](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@imported\_dinkumrocks](https://forum.kirupa.com/u/imported_dinkumrocks)\
**Post date:** [April 14, 2005, 11:55pm UTC](https://forum.kirupa.com/t/spl-date-problem/144531/1 "2005-04-14T23:55:26Z")

</div>

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

```auto
 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](http://www.dinkumrocks.com/home.asp)

thanks for any help  
-Naaman