Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
bruce_sorge
Contributor III
Contributor III

Using Date and AddYears together

Hello,

I am trying to combine the Date function and AddYears function to return data from an Oracle database for the last two years only. I am trying this:

AddYears(Date([DUE_DATE],'YYYY/MM/DD'), -2) as [Due Date]

It's returning all of the dates in the database and not just the last two years. Is there something obvious I am missing?

 

Thanks

Labels (1)
0 Replies