5 days prior to getDate() 1

[jamert]

Hi there is a column called "ReviewDate"

data in this column is of the following format:
2/18/2008 7:26:16 AM

This column has multiple years. I am writing a stored procedure and would like to grab records where

ReviewDate is 5 days earlier than todays date

How would one do this? thanks

 

[ca8msm]

getdate()-5

You should also look in the faq section if you need to strip the time portion off the date (as the above will simply remove 5 days of the current date and time).


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[jamert]

Thanks