topic Re: SQL query - rolling 3 years in App Development

SQL query - rolling 3 years

hjm35055 — Tue, 23 Oct 2018 20:43:35 GMT

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!

Re: SQL query - rolling 3 years

andrey_krylov — Wed, 24 Oct 2018 08:08:15 GMT

Hi Hannah, try this

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

or this

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