<div>
IF SELECT DATEPART(dw,GETDATE()) = 7 OR SELECT DATEPART(dw,GETDATE()) = 1<br />
Print 'WeekEnd'
</div>


IF SELECT DATEPART(dw,GETDATE()) = 7 OR SELECT DATEPART(dw,GETDATE()) = 1
Print 'WeekEnd'

<div>
like this...<br />
select dateadd(d,case datepart(dw,target) when 7 then 2<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;when 1 then 1 else 0 end) &nbsp;as target <br />
&nbsp; &nbsp;from (select dateadd(d,+40,getdate()) as target &nbsp;) as x<br />
<br />
<br />
&nbsp;
</div>


like this...
select dateadd(d,case datepart(dw,target) when 7 then 2
                                         when 1 then 1 else 0 end)  as target
   from (select dateadd(d,+40,getdate()) as target  ) as x


 

<div>
for all the suggestion about Make sure about the <br />
DateFirst <br />
<br />

</div>


for all the suggestion about Make sure about the
DateFirst



<div>
<div class="content wysiwyg-content">
I am trying to do some date manipulations in my stored procedure... For example Current date + 40 days = new date...<br />
<br />
However i need to know if this new date falls on a weekend i.e Saturday/Sunday.. if it does then i need to find the immediate working day which falls on a monday<br />
<br />
How can i achieve this in my SQL Server stored procedure... i'm using SQL Server 2000...<br />
<br />
Thanks in Advance,<br />
Collin
</div>
</div>


I am trying to do some date manipulations in my stored procedure... For example Current date + 40 days = new date...

However i need to know if this new date falls on a weekend i.e Saturday/Sunday.. if it does then i need to find the immediate working day which falls on a monday

How can i achieve this in my SQL Server stored procedure... i'm using SQL Server 2000...

Thanks in Advance,
Collin

IS there a way to find out if the date falls on a weekend

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.