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.
Ant-Green
SSC Guru
Points: 113445
More actions
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.