I’m currently working on a SQL statement that filters the last 5 years of data I’ve added the below where clause which would take me to exactly 5 years from today.

I wanted to ask how I would improve this statement to contain all data in the 5th year as well.

e.g. The data would not be from the date 16/11/2016 but from 01/01/2016 if it was run today.

Where statement:

WHERE CreatedDate > DATEADD(YEAR,-5,GETDATE())

>Solution :

DATEFROMPARTS is your friend:

WHERE CreatedDate >= DATEFROMPARTS(YEAR(GETDATE())-5,1,1)