Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Hannah, try this
Where [oe-date-ent] >= DATEADD(year, -3, GETDATE())
or this
Where Year([oe-date-ent]) >= Year(GETDATE()) -2