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]]

User related

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

Date/ Time related

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

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

LAST_MONTH

Last month in MM format

July 2023

LAST_MONTH_NAME

Last month name. E.g. December

July 2023

LAST_MONTH_SHORT_NAME

Last month short name E.g. Dec

July 2023

LAST_MONTH_YEAR

The year (formatted yyyy) that the previous month was a part of E.g if the current month is Jan 2024 it would resolve to 2023

April 2024