Magic Variables
- Karen Hogan (Unlicensed)
- Adam Voakes
- Ming Huang
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 |
|---|---|---|
| Current logged in user's username |
|
| Current logged in user's email |
|
| Current logged in user's language definition, which mirrors |
|
| Locale from language selection on the login screen (these selectable options are configured from dashboard installation on the server machine) | November 2021 |
| 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 |
|---|---|---|
| Today's date (Default: |
|
| Yesterday's date (Default: |
|
| Date of the start of week (Default: |
|
| Date of the end of week (Default: |
|
| Date of the start of last week (Default: |
|
| Date of the end of last week (Default: |
|
| Date of the start of the month (Default: |
|
| Date of the end of the month (Default: |
|
| Date of the start of last month (Default: |
|
| Date of the end of last month (Default: |
|
| Date of the start of the year (Default: |
|
| Date of the end of the year (Default: |
|
| Current calendar day in |
|
| Current month in |
|
| Current month name. E.g. | August 2020 |
| Current month short name. E.g. | August 2020 |
| Current year in |
|
| Last year in |
|
| Current week day. E.g. |
|
| Current week number. E.g. | August 2020 |
| Current time (Default: | August 2020 |
| Current date and time (Default: | August 2020 |
| Current time (Default: | August 2020 |
| Current time (Default: | August 2020 |
| Current time (Default: | August 2020 |
| Timezone on the server. E.g. | August 2020 |
| Last month in | July 2023 |
| Last month name. E.g. | July 2023 |
| Last month short name E.g. | July 2023 |
| 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 | |
| The start date of the current financial quarter based on the financial year start month defined by | November 2024 |
| The end date of the current financial quarter based on the financial year start month defined by | November 2024 |
| The start date of the last/previous financial quarter based on the financial year start month defined by | November 2024 |
| The end date of the last/previous financial quarter based on the financial year start month defined by | November 2024 |
| The start date of the next financial quarter based on the financial year start month defined by | November 2024 |
| The end date of the next financial quarter based on the financial year start month defined by | November 2024 |
| The start date of the current financial year based on the financial year start month defined by | November 2024 |
| The end date of the current financial year based on the financial year start month defined by | November 2024 |
| The start date of the last/previous financial year based on the financial year start month defined by | November 2024 |
| The end date of the last/previous financial year based on the financial year start month defined by | November 2024 |
| The start date of the next financial year based on the financial year start month defined by | November 2024 |
| The end date of the next financial year based on the financial year start month defined by | November 2024 |
CUSTOMER NEWS - Our November 24 Release Is Now Available - Download It Now!