These variables are invisible in the settings page and are maintained and/or calculated by the dashboard. User relatedVariable | Description |
---|
USERNAME
| Current logged in user's username | USER_EMAIL
| Current logged in user's email | LANGUAGE
| Current logged in user's language definition |
Date/ Time relatedDates 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
| 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 |
|