ASP/Access Date Query
- Started
- Last post
- 3 Responses
- QuincyArcher0
any time...
- nhnu0
nevermind, I'm an idiot, the date isn't coming across properly.
thanks anyway.
- nhnu0
it stole some of my text.
Basically if I use less than/equal to it errors.
Yet if I use greater than/equal to it returns all records.
- nhnu
I'm attempting to populate a page based on a user requested Date. Think a blog type site. Basically they will pick 2/22/05 and it will show them the last week starting with that date and any entries that were posted in that time period sorted by the Date DESC. Here's my problem, when I put
WHERE Date = it returns all records. Any ideas? here's the actual code.
sqlContent = "SELECT * " & _
"FROM Content " & _
"WHERE Date >= #" & rDate & "# " & _
"ORDER BY Date DESC, Time ASC"That works, as soon as I switch to < it errors