Skip to end of banner
Go to start of banner

Magic Variables

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

These variables are invisible in the settings page and are maintained and/or calculated by the dashboard.

User related

Variable

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

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

  • No labels