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_TIME`Today'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