Virtual DataPort provides a variety of functions and in this scenario I would use different date functions to achieve my end result. I would write a VQL query using a combination of functions such as GETDAY, EXTRACT, CURRENT_DATE, etc. as needed.
To know more about these functions, you could take a look at [Datetime Processing Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#datetime-processing-functions) section under the Virtual DataPort VQL Guide.
Hope this helps!