date query puzzle

[equus2]

Hi,

I need to query that can calculate the date of the 3rd Friday of every month.

Any ideas?

Thanks much

 

[earthandfire]

Have a look in the FAQs, or do a search on this forum. Variations of this question have been answered many times.

 

[equus2]

thanks

i found some clues on google using row_number functionality

 

[r937]

download the free online sample chapter (PDF) of the fabulous O'Reilly book SQL Hacks here --

http://www.oreilly.com/catalog/sqlhks/chapter/ch04.pdf

scroll down to hack #23, Second Tuesday of the Month

apply the same type of logic to get your 3rd friday

r937.com | rudy.ca

 

[ESquared]

HEY this was supposed to be an actual puzzle!