Magic Variables

These variables are invisible in the settings page and are maintained and/or calculated by the dashboard.

Variable

Description

Variable

Description

USERNAME

Current logged in user's username

USER_EMAIL

Current logged in user's email

LANGUAGE

Current logged in user's language definition

Dates are formatted using YYYY-MM-DD by default. If the Database has a format configured, it will respect that format.

Variable

Description

Available since version

Variable

Description

Available since version

TODAY

Today's date (Default: YYYY-MM-DD

 

YESTERDAY

Yesterday's date (Default: YYYY-MM-DD)

 

START_OF_WEEK

Date of the start of week (Default: YYYY-MM-DD)

 

END_OF_WEEK

Date of the end of week (Default: YYYY-MM-DD)

 

START_OF_LAST_WEEK

Date of the start of last week (Default: YYYY-MM-DD)

 

END_OF_LAST_WEEK

Date of the end of last week (Default: YYYY-MM-DD)

 

START_OF_MONTH

Date of the start of the month (Default: YYYY-MM-DD)

 

END_OF_MONTH

Date of the end of the month (Default: YYYY-MM-DD)

 

START_OF_LAST_MONTH

Date of the start of last month (Default: YYYY-MM-DD)

 

END_OF_LAST_MONTH

Date of the end of last month (Default: YYYY-MM-DD)

 

START_OF_YEAR

Date of the start of the year (Default: YYYY-MM-DD)

 

END_OF_YEAR

Date of the end of the year (Default: YYYY-MM-DD)

 

CURRENT_DAY

Current calendar day in DD format

 

CURRENT_MONTH

Current month in MM format

 

CURRENT_MONTH_NAME

Current month name. E.g. January

August 2020

CURRENT_MONTH_SHORT_NAME

Current month short name. E.g. Jan

August 2020

CURRENT_YEAR

Current year in YYYY format

 

LAST_YEAR

Last year in YYYY format

 

CURRENT_WEEKDAY

Current week day. E.g. Friday

 

CURRENT_WEEK_NUMBER

Current week number. E.g. 52

August 2020

CURRENT_TIME

Current time (Default: hh:mm:ss)

August 2020

CURRENT_DATE_TIMEToday's date (Default: YYYY-MM-DD

Current date and time (Default: YYYY-MM-DD hh:mm:ss)

August 2020

CURRENT_HOURS

Current time (Default: hh)

August 2020

CURRENT_MINUTES

Current time (Default: mm)

August 2020

CURRENT_SECONDS

Current time (Default: ss)

August 2020

TIMEZONE

Timezone on the server. E.g. GMT

August 2020