Select next business day
Posted on 2011-10-25
Below is a simple select I use for setting shipping dates. If an order is processed before 14:30 it selects today, anfter 14:30 it selects tomorrow.. pretty straight forward.
I want to modify this to consider weekdays. meaning if an order is processed on a Friday after 14:30, it should select Monday not Saturday as the answer. Using SQL server Mgmt Studio 2005
(Select DATEPART(HOUR, CURRENT_TIMESTAMP) ) >= 14
(Select DATEPART(MINUTE, CURRENT_TIMESTAMP) ) > 30
Select DATEADD(DAY, 1, CURRENT_TIMESTAMP)