-@year

Transact-SQL
1

Hi , I have a working case statement showing sales per month , I would now like to show @Year-1 . But for the life of me I can't work out what to change . Below is what I would like to achieve . Cheers Jon

DECLARE @year date

DECLARE @yearB date

SET @year = GETDATE()

SET @yearB = GETDATE()

SET @year = DATEADD(YEAR, DATEDIFF(YEAR, 0, @year), 0)

SET @yearB = DATEADD(YEAR, DATEDIFF(YEAR, 0, @yearB), 0)

2

Meant to change @yearB to @Year-1 to make it clearer

3

SET @year = DATEADD(YEAR, DATEDIFF(YEAR, 0, @year) - 1, 0)

Can't tell if that adjustment is needed for @yearB as well, but if it is, naturally add it there as well.

1 Like
4

Many thanks , that was easier than. I thought

1 Like