Home Forums SQL Server 2005 SQL Server 2005 General Discussion Find number of weekdays(Monday,Tuesday..) between two dates yearwise RE: Find number of weekdays(Monday,Tuesday..) between two dates yearwise

  • June 24, 2008 at 9:21 pm

    #833681

    bpbhalerao (6/24/2008)

    Thanks Michael,

    But I am not getting exactly how to find the total no. of weekdays in that year using the 'Tally' table. Can you please explain some what more?

    It would be better if i can have a function which will accept StartDate, EndDate and the ClientDate parameters so that if the day of 'ClientDate' was say 'Tuesday', we should get to know the total no. of Tuesdays in that year from the StartDate till end of the year.

    Thanks,

    Bhakti

    You need to be a little bit more clear on what you're trying to do... are you trying to...

    1) find things like the number of Tuesdays between two dates or are you trying to

    2) find the number of ALL weekdays between two dates?

    --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)