Post reply

Pass in Year and Quarter and get the fiscal start and end dates

  • September 25, 2010 at 11:28 am

    #227075

    Comments posted to this topic are about the item Pass in Year and Quarter and get the fiscal start and end dates

  • September 27, 2010 at 6:01 am

    #1227628

    After correcting the errors I was able to run this query. Is it just me or shouldn't the first quarter of 2010 be 01-01-2010 to 3-31-2010, not 10-01-2009 to 12-31-2010. Why does this return the last quarter of 2009 dates??

    I know some shops, like mine, have June as the beginning of the Fiscal year, so maybe his shop has October. Since there were no notes as to this, it's hard to tell.

    The solution is interesting, but the date functions cover quarters already, or SQL use to cover this.

    -Callie97

  • September 27, 2010 at 7:22 am

    #1227680

    As far as I know the quarter function went away a long time ago. Anyway, one thing to note is that this should be a single function (even though I don't like functions at all) with a @mode parameter. Say 0 for start and 1 for end.

  • May 18, 2016 at 7:17 am

    #1879865

    Thanks for the script. I actually need this for a quarterly report I'm doing.

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

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