List of dates between two dates

Hi

Anyone who know how to in query or in data compsition schema obtain list of dates between two dates (in day periodicity)???

After it, to get last slice from periodik information register to each date in obtained datelist (in query and data composition schema).???

You can supplement dates range with all dates between start and end date using the DCS report settings. These settings are available for group fields of Date type.

If you need it to get dates for query, you will need to keep this data in your infobase. For example create an information register Calendar and keep information about each day for each year when your company operates. In addition you can keep holidays information there for salary calculation purposes.

Attached Files

Download hour.png (11.27 KB)

Here are some articles, you might be interested in:
Splitting query result into time periods
Calculating totals by balance fields
Frequency distribution for documents