Thread: Simple Date Problem Please Help!
02-24-05, 19:23 #1Registered User
- Join Date
- Dec 2004
Unanswered: Simple Date Problem Please Help!
I can get the date to list all of the dates in the recordset, but when I use request.querystring("date") to specify all the recordsets with the date "2/26/2005" for example, the recordset comes up empty. Here is my sql statement:
SELECT eventdate=convert(varchar, eventdate, 101), eventtext, eventtime, location, eventtitle, eventID, picture
WHERE eventdate like 'thee' and status='live'
ORDER BY eventdate ASC
this will return everything when the browser url shows this: http://www.kapsi-western.org/calendar.asp?date= However, if we put a date in there, and made it like this http://www.kapsi-western.org/calenda...date=2/26/2005, then nothing comes up even though there is event with that date.
02-24-05, 23:08 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
Does eventdate contain time portion? And what does 'thee' mean as a comparison value for a date?"The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."