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 2:53 am

    #1575114

    I would say this is where a calendar table like this one will come into best fit. http://www.sqlservercentral.com/scripts/Date/68389/

    Then you can query it to find todays quarter, then lookup the previous quarters first day.