End Time

Endtime syntax implements convenient calendar arithmetic that can be used in portal configurations, widgets, and export settings to set interval start time, end time, and timespan (duration).

Endtime Interval Expressions:

ExpressionResult
next_month + 3 * day00:00:00 on the 3rd day of next month.
today – 1 * month00:00:00 on the same day of previous month.
For example, if current time is Dec-03 15:20, this expression returns Nov-03 00:00

Time Unis:

yearweekminute
quarterdaysecond
monthhourmillisecond

Endtime Syntax:

NameAliasDescription
timenow, empty stringCurrent time
current_minuteCurrent time rounded to the beginning of the current minute
previous_minute00 of the previous minute
next_minute 00 of the next minute
current_hourCurrent time rounded to the beginning of the current hour
previous_hour00:00 of the previous hour
next_hour00:00 of the next hour
current_daytoday00:00:00 of the current day
previous_dayyesterday00:00:00 of the previous day
next_daytomorrow00:00:00 of the next day
previous_working_day00:00:00 of the previous working day
next_working_day00:00:00 of the next working day
previous_vacation_day00:00:00 of the previous vacation day
next_vacation_day00:00:00 of the next vacation day
next_week00:00:00 on Monday of next week
next_month00:00:00 on the first day of next month
next_quarter00:00:00 on the first day of next quarter
next_year00:00:00 on the first day of next year
previous_week00:00:00 on Monday of the previous week
previous_month00:00:00 on the first day of previous month
previous_quarter00:00:00 on the first day of of previous quarter
previous_year00:00:00 on the first day of previous year
current_week00:00:00 on Monday of the current week
current_month00:00:00 on the first day of the current month
current_quarter00:00:00 on the first day of the current quarter
current_year00:00:00 on the first day of the current year
last_working_day00:00:00 of the last working day of the current month
last_vacation_day00:00:00 of the last vacation day of the current month
first_day00:00:00 of the first day of the current month
first_working_day00:00:00 of the first working day of the current month
first_vacation_day00:00:00 of the first vacation day of the current month
mondaymon00:00:00 on the most recent Monday
tuesdaytue00:00:00 on the most recent Tuesday
wednesdaywed00:00:00 on the most recent Wednesday
thursdaythu00:00:00 on the most recent Thursday
fridayfri00:00:00 on the most recent Friday
saturdaysat00:00:00 on the most recent Saturday
sundaysun00:00:00 on the most recent Sunday
‘date-format’Supported formats:
YYYY-MM-DD HH:mm:ss – Specific date and time
YYYY-MM-DD – 00:00:00 on specific day
2015-04-22T00:00:00Z – Date in ISO format
Example 1: 2015-04-22 00:00:00
Example 2: 2015-04-22 00:00
Example 3: 2015-04-22
ISOISO format is supported.
For example: 2015-07-08T16:00:00Z
ISO examples: 2015-07-24T16:10:15Z, 2015-07-24T13:10:15+03:00, date('2015-07-24T16:10:15Z')

See documentation on github.com for more information.