Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Second Last work day of month RE: Second Last work day of month

  • May 2, 2014 at 7:50 am

    #1710339

    praveen.arokiam (5/2/2014)

    Hi,

    Thanks for the reply. Yes the workday runs through Monday to Friday

    So a minor tweak to what I posted will get you the last Friday of any given month.

    declare @ThisDate datetime = getdate();

    with LastSeven as

    (

    select DATEADD(day, -DayNum, dateadd(mm, datediff(mm, 0, @ThisDate) + 1, 0)) as MyDay

    from

    ( Values(1),(2),(3),(4),(5),(6),(7)) d(DayNum)

    )

    select *

    from LastSeven

    where DATENAME(weekday, MyDay) = 'Friday'

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/