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

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)

Published Saturday, April 26, 2008 11:10 AM by Jalpesh P. Vadgama
Filed under: , , , ,

Comments

# re: Previous week startdate and enddate in sql server 2000,sql server 2005

Tuesday, May 13, 2008 3:44 AM by Arun Pal

Thanks man. It works