Following are the some tricky code to find previous week startdate and enddate in sql server 2000/2005
Set @STimeStamp=GETDATE() set @PStartDate=@STimeStamp-DATEPART(dw,@STimeStamp)-6 set @PEndDate=@STimeStamp-DATEPART(dw,@STimeStamp)
Thanks man. It works