WHERE logdate >= dateadd(dd, datediff(dd,0, getdate()),0) AND logdate < dateadd(dd, datediff(dd,0, getdate())+1,0)
will get you today's records. Play with that and you should be able to get x days past easily
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability