SQL Server 2008

Get First Day of the Quarter

I’m building a Stored Procedure and Report that needs to limit to data created in the previous quarter, only. The assumption is the report will be run on the first day of a new quarter, but could be run any time within the current quarter.

Can be achieved like so:

Share on Google Plus


Australian. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf R. SQL Server Developer. Three sons. One daughter. Last Trip: Tasmania.

Leave a comment

Your email address will not be published. Required fields are marked *