Today I get instance when I need to get start date of quarter by quarter number and year.
Below is code for getting quarter start date by quarter number and year.
DECLARE @Quarter int = 1
DECLARE @Year int = 2016
DECLARE @dateString varchar(100)
SET @dateString = cast(@Year AS varchar(10)) + '-' + cast((3 + ((@Quarter - 1) * 3)) AS varchar(10)) + '-' + '1'
PRINT @dateString
I hope this will help someone. Comments and suggestions are welcome.
Thanks