I'm trying to have a query that pulls data concerning upcomming events and displaying it on a web page(ASP) ONLY if the event is in the future or today. The query I have right now (that doesn't work) is <BR>[code language="VBScript"]<BR>SQL="select * from events WHERE m_date >=" & date() & " ORDER BY ID DESC;"[/code]<BR><BR>Right now it returns all the rows regardless of date basically ignoring my WHERE clause. I think this is because it doesn't know how to compare m_date and the data pulled from date(). I'm also guessing this isn't hard to fix. Does anyone have any ideas? Please please please don't tell me to read the FAQ's unless you know where to look in them cause I've looked and I couldn't find it. Thanks in advance.