DateDiff Question 1

[dvannoy]

I have a field called date_expired I'm trying to run a query that will take the date_expired field and show records that will expire within 30 days from now.

any help would be appreciated

thanks

 

[gmmastros]

Select *
From   YourTable
Where  Date_Expired >= GetDate()
       And Date_Expired <= DateAdd(Day, 30, GetDate())

This should get you really close.

Please be aware that GetDate() includes date and time. If your date_expired column includes time information as well as date information, then you should be very careful about rows that expire in exactly 30 days.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[dvannoy]

perfect thanks.....