SQL 2005 Year End issue

[speedman_2001]

Wondering if anyone has heard of such a problem before. I'm running SQL 2005 and it appears I am having 2 similar issues. If I run a stored proc looking for anything with dates between 2008-DD-MM and 2008-12-31, I get no results. Also, if I attempt to run with dates between 2008-DD-MM and 2009-DD-MM it will only pull data from 2009.

If I remember correctly I had this same issue going from 2007 to 2008. If anyone needs anymore information let me know. Thanks in advance for the help.

J

 

[boblarson]

When working with SQL you need to format the dates into U.S. date format (I know - not fair but that's how it was designed).

 

[boblarson]

So it would be

Between mm/dd/2008 And 12/31/2008

 

[speedman_2001]

Makes sense. In fixing that I think I have found some other problems created by the original programmer that may be causing it as well. Thanks for the help and quick repsonse.