Hi Chris is I get the curent week number from my app then pass to sql along the way off

Select * from dbo.DocketTB Where DatePart(Week,Docket_EngFinish ) = @weeknum

can you see any issues?