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?