
Contributor III
2021-01-12
09:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- date
559 Views
0 Replies
