How come that this doesn't work in an sql question?<BR>sql = "SELECT name, date FROM year WHERE date = <%= today %>"<BR><BR>
and think it through!
Thanks for nothing, Pete. Here's the solution:<BR>sql="SELECT name,date FROM year WHERE date = '" & today & "'"<BR>
Hey sometimes people need to simply work through some of their stuff before immediately asking it here.