DECLARE @AnyDate DATETIME
SET @AnyDate = GETDATE()
SELECT @AnyDate AS 'Input Date',
DATEADD(q, DATEDIFF(q, 0, @AnyDate), 0)
AS 'Quarter Start Date',
DATEADD(d, -1, DATEADD(q, DATEDIFF(q, 0, @AnyDate) + 1, 0))
AS 'Quarter End Date'
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter