Formatting Date Variables Using Display Format
Formatting the Date variable is relatively easy to do. Each Date variable has an input box under Type Specific in the Variable Settings called Display format.
It is in this input box that you can modify the output displayed value. Be default it is set to:
MM/DD/YYYY
which will output:
01/03/2019
However, you could change it to:
MM-DD-YYYY
which will output:
01-03-2019
Date Formatting
While changing the forward-slash into a line is cool, what is cooler is changing how the day, month, and year are displayed.
Below you will find options for each part of the date.
Month
Specifier | Displays | Output Example |
M | Displays the month as a number without a leading zero | 1 |
MM | Displays the month as a number with a leading zero | 01 |
MMM | Displays the month as an abbreviation | Jan |
MMMM | Displays the month as a full name | January |
Day
Specifier | Displays | Output Example |
D | Displays the day as a number without a leading zero | 3 |
DD | Displays the day as a number with a leading zero | 03 |
E | Displays the day as an abbreviation | Thu |
EEEE | Displays the day as a full name | Thursday |
Year
Specifier | Displays | Output Example |
YY | Displays the year as a two-digit number | 19 |
YYY | Displays the year as a four-digit number | 2019 |
YYYY | Displays the year as a four-digit number | 2019 |