Need a Query to find a Older date that is less than 90 business days

• Anjan@Sql

  SSCrazy

  Points: 2316

  More actions

  February 12, 2015 at 11:37 pm

  #398014

  select DateAdd(dd,-90,getdate()) it gives the 90 days older date but i want to exlude the weekdays and holidays (saturday ,sunday,holiday)

  Any help would be appreciated.

  As we dont have permission to call a function or Sp in high level environments looking for a simple query .

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  February 12, 2015 at 11:58 pm

  #1777411

  use a calendar table, omit all the days that fall on Sat/Sun and Holidays. Sort in descending order and return the TOP value?