Given a date, return nth weekday of month?

• analoglife23

  SSC Veteran

  Points: 294

  More actions

  July 17, 2012 at 10:45 am

  #259571

  Hi there -

  I can't seem to gather the steam to figure this out today.

  I need to find out what the nth weekday of the month is when given a date.

  Ex.

  today is 7/17/2012

  I want to see that it is the 3rd Tuesday of this month (3 Tuesday - something to that effect).

  I must be making this out to be harder than it is.

  Thanks for any input you have,

  matt

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 17, 2012 at 11:03 am

  #1513728

  Start with this:

  SELECT

  ceiling(DAY(GETDATE()) / 7.),

  DATENAME(dw, GETDATE()),

  ceiling(DAY('20120731') / 7.),

  DATENAME(dw, '20120731');

• analoglife23

  SSC Veteran

  Points: 294

  More actions

  July 17, 2012 at 2:14 pm

  #1513878

  Thank you! Perfect, I knew it had to be something simple.:blush:

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  July 18, 2012 at 12:51 am

  #1514018

  Lynn Pettis (7/17/2012)

  ---

  Start with this:

  SELECT

  ceiling(DAY(GETDATE()) / 7.),

  DATENAME(dw, GETDATE()),

  ceiling(DAY('20120731') / 7.),

  DATENAME(dw, '20120731');

  I LOVE SIMPLE!!!

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• kevin.unglesbee

  SSC Eights!

  Points: 942

  More actions

  December 14, 2012 at 7:59 am

  #1568722

  I have written an article solving exactly this problem with a nice UDF. It is here: Nth Weekday of the Month

  [/url]

• lhayes.email

  SSC Rookie

  Points: 29

  More actions

  June 29, 2016 at 3:47 pm

  #1887748

  Works like a charm, thanks!