Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

check that a datetime value is not older than 1 month

Status
Not open for further replies.

mrp9090

Programmer
May 22, 2006
71
GB
How do you check that a datetime value is not older than 1 month?
 
Select * from myTable where DateTimeField > dateadd(mm,-1,getdate())

"I'm living so far beyond my income that we may almost be said to be living apart
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top