Magic Variables

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

When using Magic Variables, please ensure they are enclosed in square brackets e.g. [[TODAY]]

Variable

Description

Available since version

Variable

Description

Available since version

USERNAME

Current logged in user's username

 

USER_EMAIL

Current logged in user's email

 

LANGUAGE

Current logged in user's language definition, which mirrors LANGUAGE_LOCALE

 

LANGUAGE_LOCALE

Locale from language selection on the login screen (these selectable options are configured from dashboard installation on the server machine)

November 2021

LOCALE

Locale of a user's browser, which generally is used for date formatting (this reflects whatever locale a user set on their browser)

November 2021

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