You can translate the question and the replies:

Syntax for a Condition: Last Ten Years

Hello, Here is my current condition: todate('MM/dd/yyyy', ITEM.datefiled) >= todate('MM/dd/yyyy','08/12/2005') I would like to modify this so that it will only bring back the last ten years from whatever date it is currently. Thank you
syntax itpilot condition date field
user
12-08-2015 15:20:55 -0400
code

1 Answer

Hello, You can use the addYear function which accepts a date and an increment (positive or negative). This can be found as part of the Denodo XtraFuncs extension that you can find in the Denodo Connect section of the Support site. Hope this helps!
Denodo Team
13-08-2015 04:08:01 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here