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?

  • 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.