Jun 14, 2006 #1 mrp9090 Programmer Joined May 22, 2006 Messages 71 Location GB How do you check that a datetime value is not older than 1 month?
Jun 14, 2006 #2 hmckillop Programmer Joined Oct 30, 2001 Messages 1,540 Location GB 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 Upvote 0 Downvote
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