SQL statement BETWEEN

Page 1 of 1

5 Replies - 5181 Views - Last Post: 21 May 2002 - 02:09 PM Rate Topic: -----

#1 klewlis  Icon User is offline

  • cur tu me vexas?

Reputation: 8
  • View blog
  • Posts: 1,723
  • Joined: 09-November 01

SQL statement BETWEEN

Posted 03 May 2002 - 04:17 PM

I'm trying to get records between two dates, like this:

strSQL = "SELECT * FROM table WHERE page = '" & page & "' AND date BETWEEN " & startDate & " AND " & endDate

But it's returning 0 records. I've made sure that my date formats match... what am I missing? Does SQL not like to compare dates?

Is This A Good Question/Topic? 0
  • +

Replies To: SQL statement BETWEEN

#2 klewlis  Icon User is offline

  • cur tu me vexas?

Reputation: 8
  • View blog
  • Posts: 1,723
  • Joined: 09-November 01

Re: SQL statement BETWEEN

Posted 03 May 2002 - 04:20 PM

nevermind... found it at 4guys... had to quote the dates... :)
Was This Post Helpful? 0
  • +
  • -

#3 Fygar  Icon User is offline

  • I liek milk!!1
  • member icon

Reputation: 3
  • View blog
  • Posts: 4,358
  • Joined: 28-March 02

Re: SQL statement BETWEEN

Posted 09 May 2002 - 08:15 AM

4guys is a cool site...
Was This Post Helpful? 0
  • +
  • -

#4 The Neoracle  Icon User is offline

  • Check, check, 1, 2.
  • member icon

Reputation: 21
  • View blog
  • Posts: 4,097
  • Joined: 30-March 01

Re: SQL statement BETWEEN

Posted 09 May 2002 - 09:57 AM

4guys?
Was This Post Helpful? 0
  • +
  • -

#5 klewlis  Icon User is offline

  • cur tu me vexas?

Reputation: 8
  • View blog
  • Posts: 1,723
  • Joined: 09-November 01

Re: SQL statement BETWEEN

Posted 09 May 2002 - 09:58 AM

www.4guysfromrolla.com

best ASP site out there :)

Was This Post Helpful? 0
  • +
  • -

#6


Reputation: 0

Re: SQL statement BETWEEN

Posted 21 May 2002 - 02:09 PM

4guys is outstanding as a resource, but if you are just starting out htmlgoodies has a pretty good start and paco has some very cool wizards and code generators that will help you actually make pages even if you hardly know what you are doing.  

Hoopster


Was This Post Helpful? 0
Page 1 of 1