2025-2Q: [RPT] Auto Reports flexible Date fields 

A new feature has been added to enhance the Auto Reports functionality. It allows to flexibly calculate a date for the date fields required by some reports.

The option can be found under Settings -> Cronjobs

The flexible date entry was added to help address requirements of some reports for calculation of date boundries. For example 'Date From' and 'Date To' fields that can not always be pre-defined as the dates will change month to month in cases where for example we want to run a report for last couple months.

To use data calculation use following format in the date fields:

CALCDATE:[DATE CALCULATION EXPRESSION]

Use of CALCDATE: will enable the date calculation engine and will process the [DATE CALCULATION EXPRESSION] to generate the date for the field.  The date calculation expression should be constructed of following tokens:

• %NOW% - which represents the current day date (in server time/timezone)

• %FIRSTDAYOFCURRENTMONTH% - which represents the first day of the current month (in server time/timezone)

• [-|+] NUMBER  [day|month|year] - an offset that will be added / substracted from the date

Examples:

• current day -> CALCDATE:%NOW%

• one month ago -> CALCDATE:%NOW% - 1 month

• one year and one month ago -> CALCDATE:%NOW% - 1 year - 1 month

• first day of the current month -> CALCDATE:%FIRSTDAYOFCURRENTMONTH%

• first day of the previous month -> CALCDATE:%FIRSTDAYOFCURRENTMONTH% - 1 month

• first day of the next month -> CALCDATE:%FIRSTDAYOFCURRENTMONTH% + 1 month