LATEST DATE

[Nsan]

Using SQL Server 2005 I need to return data based on the latest(highest) date value in a column and 7 days back. Any help would be great.

 

[gmmastros]

What have you tried so far?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[ariftvt]

try this

Select * from table where date_column between getdate() and getdate()-7

 

[jbenson001]

That will only work if you want to consider the time portion of the datetime column. To get a true 7 day difference, you have to ignore the time.

 

[bborissov]

and also GETDATE() is not necessary MAX(DateField) in the table

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[RyanEK]

Hi,

I would use the following...

select * 
from [Table] 
where [DateField] between dateadd(d,-7,floor(cast(getdate() as float))) and getdate()

Ryan

 

[r937]

... where date_column between getdate() and getdate()-7

that will never work, ever


it's like saying

... where integer_column between 42 and 35

never, ever, ever




r937.com | rudy.ca

 

[ariftvt]

 

[Nsan]

Great information..

Thanks..