You can translate the question and the replies:

how to filter recent 3 years data in denodo vql

How to filter recent 3 years data
user
20-07-2021 04:48:22 -0400
code

1 Answer

Hi, I would filter out the last three years out using the ADDYEAR() function. I would use a VQL statement with a where clause when the dates are greater than the ADDYEAR() function with a -3 for the increment parameter. For an overview of the function for processing dates, I would take a look at the [Datetime functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/datetime_functions/datetime_functions) section in the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
20-07-2021 17:52:50 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here