Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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