Date question

[icemel]

Hi,

Thanks for eveyone's help so far... it's been very helpful!

My question now is this... I have a query that needs to find all the records that are within a certain time frame, see below:

WHERE effectiveDate >= GETDATE()-7 and effectiveDate <= GETDATE()

The problem is, GETDATE() starts at the current date and TIME. I would like to start my beginning date to today's date minus seven days, but starting at MIDNIGHT, not 1:30 in the afternoon or whatever time it is I run this query.

How can I do this??

THANKS

 

[icemel]

found it -

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)