Post reply

Get week no for the cuurent date between two dates

  • November 8, 2012 at 12:17 am

    #284539

    I have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates . Is this possible ?

  • November 8, 2012 at 12:53 am

    This was removed by the editor as SPAM

  • November 8, 2012 at 1:18 am

    #1557036

    sri.chithu.selva (11/8/2012)

    I have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates . Is this possible ?

    This explanation is really poor. If you'd like us to spend our time helping you, please explain the problem, with examples where words are not working.

  • November 8, 2012 at 7:29 am

    #1557177

    sri.chithu.selva (11/8/2012)

    I have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates . Is this possible ?

    What defines a "week number" at your company? For example, are you usig ISO week numbers, SQL week numbers, or some form of special "fiscal week" numbers? Are the start and end dates also the start and end dates of a single full week, a partial week, or do they span multiple weeks?

    In any case, the best bet here would probably be to build a "Calendar Table". You can find many examples and some usage examples by doing a web search on the term.

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply