Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DateAdd Function

Author  Topic 

drpkrupa
Yak Posting Veteran

74 Posts

Posted - 2010-04-12 : 16:45:21
I want to use DateAdd Function. I want to add 10 business days to the current day as soon as user add record into SQL table.
I am using below script.

dateadd(day,10,getdate()) - This will add up weekend too.

I want a add only business day. How can I achive this task.

Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-04-12 : 20:18:48
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130526


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -