SQL query - rolling 3 years

[hjm35055]

Hi

I am working in Qlik Sense and connected to a SQL database. Does anyone know what my where clause would be to bring in the previous 3 years based off of the field "oe-date-ent" (not shown)?

Thank you!

[andrey_krylov]

Hi Hannah, try this

Where [oe-date-ent] >= DATEADD(year, -3, GETDATE())

or this

Where Year([oe-date-ent]) >= Year(GETDATE()) -2