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
20-07-2021 04:48:22 -0400

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]( section in the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
20-07-2021 17:52:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here