Home Forums SQL Server 7,2000 General Modifying A Date So That It Is Neither A Weekend Or Holiday? RE: Modifying A Date So That It Is Neither A Weekend Or Holiday?
Steve Jones - SSC Editor
SSC Guru
Points: 734552
More actions
June 26, 2013 at 10:36 am
#1627646
I'd build a calendar tables (there are articles on this site for that). essentially populate it with all days, mark weekends, holidays, and other days. That way you can join with that table and determine the next available "work" day.