Date Query

[koeniga]

I am attempting to pull information from a database and the main criteria of
how I retrieve the information in a date format.

The startdate and enddate are both datetime in a SQL server 2000 database.

When I put in my query I am returning nothing on this time when in the
database I have the following information.

23 3 1/1/2006 3/4/2006 0 2980 Winter

24 3 3/4/2006 5/27/2006 1 4980 Spring

25 3 5/27/2006 8/26/2005 1 6380 Summer

26 3 7/3/2006 7/10/2006 1 7380 4th of July

27 3 7/10/2006 8/26/2006 1 6380 Summer

28 3 8/26/2006 9/9/2006 1 5380 Late Summer

29 3 9/9/2006 10/14/2006 0 4680 Fall

30 3 10/14/2006 11/18/2006 0 2980 Late Fall

31 3 11/18/2006 11/25/2006 1 4680 Thanksgiving

32 3 11/25/2006 12/23/2006 0 2980 Late Winter

33 3 12/23/2006 12/30/2006 1 3980 Christmas


What am I doing wrong?



SELECT *
FROM table
WHERE (Startdate > '07/07/06') AND (Enddate < '07/14/06')

[mxstu]

Nothing is returned because your table contains zero (0) records where the
StartDate is greater than '07/07/2006' AND then EndDate is less than
'07/14/2006'. What information are you trying to retrieve?