Date Query

[jjmusicpro]

Hi,

 

I was running a date query and it seems my 2008 querys work, however when i look at 2009 querys, it goes back in time.

 

SELECT TOP 1 * FROM Table where P1Name='Billy Jones'and Date BETWEEN '12/21/2008' AND '1/9/2009' ORDER BY Date DESC

[jjmusicpro]

For example if i run this

 

SELECT * FROM Table WHERE Date BETWEEN '12/10/2008' AND '12/23/2008'

 

It works, however if I run this

 

SELECT * FROM Table WHERE Date BETWEEN '12/10/2008' AND '12/23/2009'

 

I bring Back NO records

[machupicchu]

are you using MySQL?

 

try the dates in the following format:

 

2009-12-23

[machupicchu]

also, next time you should post this in one of the SQL / Database Forums 

[jjmusicpro]

I am using MSSQL thats what they have installed not MYSQL.

 

SO any ideas?

 

Strange.......

 

 

This works

SELECT * FROM Table WHERE Date BETWEEN '11/10/2008' AND '12/25/2009'

SELECT * FROM Table WHERE Date BETWEEN '12/10/2008' AND '12/25/2009'

BUt it only brings back stuff from 2008 NOT 2009

 

This does not work

SELECT * FROM Table WHERE Date BETWEEN '11/10/2008' AND '1/25/2009'

 

If I run this

 

SELECT * FROM Table WHERE Date BETWEEN '1/1/2009' AND '12/25/2009'

It brings back ALL records, and this is wrong.