Add new year range columns

SELECT cast (DATEPART(yyyy,getdate()) as varchar(20)) + ‘-‘ + cast(datepart(yyyy, dateadd(yy, 1, getdate())) as varchar(20))

Leave a Reply

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