You can translate the question and the replies:

Get list of dates between two dates

How can I fetch all the list of dates between two dates ? Is there a system calendar that I can refer too ?
user
26-06-2019 07:04:24 -0400

1 Answer

Hi, I would first go through [Datetime Processing Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions) available in Denodo to get the list of days between two dates. If the existing functions do not produce the expected results then I will go ahead and create a new Custom function. I will refer [Developing Custom Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_custom_functions/developing_custom_functions) section of Virtual DataPort Developer Guide for more details on the same. I find using Denodo 4E plugin easy to develop custom functions because it adds the required libraries to the classpath of the project, provides the capability of debugging the extension you are developing, etc. The [Denodo4E User Guide](https://community.denodo.com/docs/html/browse/7.0/denodo4e/index#denodo4e-user-guide) explains how to use it. Hope this helps!
Denodo Team
27-06-2019 05:45:54 -0400
You must sign in to add an answer. If you do not have an account, you can register here