Home Forums SQL Server 2008 SQL Server 2008 - General How to first date of the previous Quater of the given date. RE: How to first date of the previous Quater of the given date.

  • January 9, 2013 at 3:54 am

    #1575141

    I agree with Anthony... a calendar table is probably a better idea, but this should get you the first day of the previous quarter.

    declare @d datetime

    set @d = getdate() -- or whatever date you want to test

    select DATEADD(quarter,DATEDIFF(quarter,0,@d)-1,0)