dates issue

Question

declare @date datetime = '2011/09/25',@days = 2
requirement is for the given days previous 2 days has to calculate like

set @date = dateadd(dd,-@days,@date)

suppose in between those todays if any saturday and sunday comes in then it should return the previous dates.

suppose if we pass @days as 1, then it should check if the previous day is a saturday or sunday, if it is saturday or sunday then previous day should return

Answer 1

0

Hi, Please try this code and let me know if you have any concerns regarding the code.

declare @date datetime = '2011/09/25',@days int= 13,@date1 datetime
set @date1 = dateadd(dd,-@days,@date)
select  
case
       when datename(DW,@date1)='saturday'   
         then dateadd(dd,-1,@date1)
       when datename(DW,@date1)='sunday' OR datename(DW,@date)='sunday'
         then dateadd(dd,-2,@date1)
else dateadd(dd,-@days,@date)
end as result

answered Feb 24 '12 at 07:19 AM

sanjeev.matte
31 ● 3 ● 6 ● 10

(comments are locked)

dates issue

Follow this question

Related Questions