Find First and Last Day of the Current Quarter in SQL Server

I was recently working on a requirement where the user wanted a report with data from the First day to the Last Day of the current Quarter

Here's a simple way to find the Find First and Last Day of the current quarter in SQL Server 2005/2008


SELECT DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0) as FirstDayOfQuarter


SELECT DATEADD(qq,DATEDIFF(qq,-1,GETDATE()),-1) as LastDayOfQuarter




OUTPUT


FirstDayOfQuarter         LastDayOfQuarter


2009-04-01 00:00:00.000   2009-06-30 00:00:00.000


at

9 comments:

  1. darksanderFebruary 18, 2010 at 5:52 AM

    Thanks a lot for your gem :)

    ReplyDelete
  2. SerginhoJuly 9, 2010 at 1:07 PM

    Thank you very much, also it works for first day of the month, quarter and year.

    It's really a gem.

    ReplyDelete
  3. AnonymousJuly 12, 2010 at 12:06 AM

    Thats great - any ideas how to do this in the code of ssrs i.e. in c#?

    Thanks :)

    ReplyDelete
  4. AnonymousAugust 10, 2010 at 12:42 AM

    Thanks..its working..
    But i didn't get d logic..

    If possible plz Mention d logic

    ......MAster ANil

    ReplyDelete
  5. UnknownOctober 13, 2010 at 1:08 PM

    This comment has been removed by the author.

    ReplyDelete
  6. AnonymousOctober 13, 2010 at 1:09 PM

    Thank you very much. Is there a easy way to get the first day and the last day of the previous quarter?

    ReplyDelete
  7. Suprotim AgarwalOctober 13, 2010 at 9:06 PM

    To get the First Day and Last Day of 'Last' quarter, try this query

    SELECT DATEADD(qq,DATEDIFF(qq,0,GETDATE())-1,0) as FirstDayOfLastQuarter

    SELECT DATEADD(qq,DATEDIFF(qq,0,GETDATE()),-1) as LastDayOfLastQuarter

    ReplyDelete
  8. billJanuary 12, 2011 at 10:49 AM

    beautiful code!

    I needed first and last days of *last* quarter for my requirements, so I did:

    SELECT DATEADD(qq,-1,DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0))
    SELECT DATEADD(qq,-1,DATEADD(qq,DATEDIFF(qq,-1,GETDATE()),-1))

    ReplyDelete
  9. billJanuary 12, 2011 at 10:51 AM

    oops--sorry--didn't see your last comment where you already did the first and last day of last quarter!

    ReplyDelete