Previous week startdate and enddate in sql server 2000,sql server 2005

My Another Blog

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)

Posted: Apr 26 2008, 11:10 AM by Jalpesh P. Vadgama | with 1 comment(s)

Comments

Thanks man. It works

# May 13, 2008 3:44 AM