Posted by paulmac106 on 11/30/06 13:34

Hi.

I utilize the Calendar table, and I'm able to find how many working
days between 2 dates, but does anyone use this table to find the 2nd or
5th working date?

if 11/30/06 then 12/4/06

I'm sure it's not too difficult but i can't seem to get it to work

(select caldate from calendar where...?...and workingday = 'Y')


thanks,
Paul

• Next in forum: Oracle Sequence/Link 2 MS SQL SERVER 2005
• Prev in forum: Re: Inserting into a tmp table using a View --- Please help using SQL Query Analyzer
• Thread view: Find 2nd Working Day

[Reply to this message]