...
| Info |
|---|
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 |
|---|
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 full 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 |
| Date of the start of next week (Default: | January 2025 |
| Date of the end of last week (Default: | January 2025 |
| Date of the start of next month (Default: | January 2025 |
| Date of the start of end month (Default: | January 2025 |
| Date of the start of the last year (Default: | January 2025 |
| Date of the end of the last year (Default: | January 2025 |
| Date of the start of the next year (Default: | January 2025 |
| Date of the end of the next year (Default: | January 2025 |
| Date of the start of the current quarter (Default: | January 2025 |
| Date of the end of the current quarter (Default: | January 2025 |
| Date of the start of the last quarter (Default: | January 2025 |
| Date of the end of the last quarter (Default: | January 2025 |
| Date of the start of the next quarter (Default: | January 2025 |
| Date of the end of the next quarter (Default: | January 2025 |
| Current calendar day in | January 2025 |
| Current calendar day with its appropriate suffix. E.g. | January 2025 |
| Current month in | January 2025 |
| Current week day abbreviated. E.g. | January 2025 |
| Last month in | January 2025 |
| Next year in | January 2025 |
| Next month in | January 2025 |
| Next month full name. E.g. | January 2025 |
| Next month short name E.g. | January 2025 |
| Next month in | January 2025 |
| The year (formatted yyyy) that the next month is a part of. E.g. | January 2025 |