Getting the first Monday after the third Friday

1 vote

2 answers

1281 views

                          I have seen on this site how to get the the third Friday of the month:


    select quote_date
    FROM table
     where  datename(weekday, quote_date) = 'Friday'
    and datepart(day, quote_date)>=15 and datepart(day, quote_date)<=21;

How would I get the first Monday after this third Friday?
                        

Asked by Ivan (127 rep)

Aug 12, 2021, 11:48 PM
Last activity: Aug 13, 2021, 06:00 PM

Getting the first Monday after the third Friday

Related Questions