For your scenario, I would use **Where Conditions** option in the Virtual DataPort Administration Tool in order to filter the data based on the between range values.
For instance, I would use the **Specify Where expression** option under the Where Conditions > Edit tab of the derived view for adding the complex condition. Further, I would set the condition in the Where conditions tab as below example format:
However, in order to manipulate the date function, you can refer to the[ Datetime Processing Functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions) section under the Virtual DataPort VQL Guide for more information.
Hope this helps!