SELECT MyField FROM MyTable WHERE MyDate BETWEEN GetDate()-5 AND GetDate()<BR><BR>Of course, that's SQL Server (you didn't specify anything else).<BR>Of course, all this can be found using a simple search of either Books Online or Google.<BR><BR>Craig.
http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=compare+dates+sql+server<BR><BR>Please don't insult our intelligence. Either you didn't search, or you need to learn what to search for.<BR><BR>Craig.
I do appreciate the help but I did a search "MS SQL Server comparing dates" and didn't come up with much. I also check the BOL and found the DATEADD and DATEDIFF...I guess if I looked further I would have seen the GETDATE function.