Counting Fridays in a Quarter

rstelma · April 19th, 2006, 04:33 PM

Hi All,

I've searched the archives here and haven't been able to find anything on this topic.

I need to be able to count the number of Friday's in a quarter. And how to count the number of Fridays left in a quarter. I have to create work orders for scheduling jobs. These work orders will be assigned to the Fridays in each quarter.

Your response is greatly appreciated. Thank you.

Richard

rstelma · April 24th, 2006, 12:00 PM

OK... I'm making some sort of progress here.

I can find the first Friday of the year.

Code:

SELECT DateAdd(wk, DateDiff(wk, 0, DateAdd(yy, DateDiff(yy, 0, GetDate()), 0)), 4);

Next I'll be working to get the first Friday of the Quarter.

Thanks for any suggestions.

Richard

rstelma · April 24th, 2006, 03:10 PM

OK... I figured it out.

I created a Fridays table. Used this script in Classic ASP to enter in 10 years of Fridays.

Code:

    theCounter = 0
    Do until theCounter >= 3640
    SQL2 = "select dateadd(dd, (datepart(dw, '1/1/2006') * -1) + 6, '1/1/2006') + "& theCounter & " AS 'TheDate';"
    Set oRS2 = oConn.Execute(SQL2)
    thefriday = FormatDateTime(oRS2(0),2)
    SQL3 = "INSERT INTO Fridays (FridayDate,Status) Values ('"&thefriday&"', 1);"
    oConn.Execute(SQL3)
    theCounter = theCounter + 7
    Loop

Now all I have to do is use BETWEEN to find any info on Fridays that I might need.

Hope someone else can use this too.

Richard