Embedded Files
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
Published Date: April 2025
Engineer: MG
Contact Azotel Support:
Need more help? Save time by creating a maintenance ticket to Azotel through your instance or email support@azotel.com.
Page updated
Report abuse