Custom Formatting Date Type Column
Custom date format allows you to set the desired format for the date field implicitly and apply formatting based on fiscal year. This can be supported for all date formats such as year, month, date, day, and many more.
NOTE: Custom date format support is only applicable for chart and grid widgets.
Configuring custom date format to date field
The custom date format option is applicable only for the date-time type of dimension column. To configure the custom date format settings, open the Date Settings dialog from the Settings option by clicking Settings icon.
By clicking Edit.. menu item, Date Settings dialog will open as follows.
Date Settings dialog have following options that allows you to customize date field with the applicable date format:
To clear the custom date format settings for date field, click clear in the settings drop-down menu. This menu item is enabled only when the date field is already configured with custom date settings.
How to customize date field with custom date format
Date field can be customized by Format and Fiscal year start options provided in Date Settings dialog.
Format
You can customize the date format of the date field using various custom date format options based on the fiscal year. For example, if the date format is Year, then the year format can be customized by using the provided default options like 2016-2017...or 16-17....
Follow these steps to apply predefined date format:
-
Click
Formatdropdown. -
Choose any one of the predefined format option as follows.
The supported built-in date format types are provided in the following table.
| Types | Formats |
| Year | 2016, 2017, ... |
| 16, 17... | |
| Quarter | Quarter 1, Quarter 2 |
| Q1, Q2, Q3, Q4 | |
| 1, 2, 3, 4 | |
| Month | Jan, Feb, Mar |
| January, February | |
| 1, 2, 3...12 | |
| 01, 02, 03...12 | |
| Hour | 00, 01, 02, 03... |
| 1 AM, 2 PM.. | |
| 0, 1, 2, 3.... | |
| Minutes | 00, 01, 02, 03... |
| 0, 1, 2, 3... | |
| Seconds | 00, 01, 02, 03... |
| 0, 1, 2, 3... | |
| Quarter Year | Quarter 1 2017, Quarter 2 2018 |
| Q1 2017, Q2 2017 | |
| Month Year | Jan 2016, Feb 2017 |
| January 2016, February 2017 | |
| Date Hour | 23/07/2017 00 |
| Week of Year | 00, 01, 02, 03... |
| Week 0, Week 1, Week 2... | |
| Week 00, Week 01, Week 02... | |
| Day | 00, 01, 02, 03...31 |
| 1, 2, 3...31 |
Custom Format
You can see the Custom option under the Format drop-down which allows the user to customize the date format based on the requirement.
For example, if the date format is Date, then the format will be customized by MM/dd/yyyy, dd-MM-yyyy, and more.
Follow these steps to apply custom format:
-
Click
Formatdropdown. -
Select
Customoption. -
A textbox will be enabled which is named as
Custom Format. -
Add desired formats which can be referred from supported format information while hovering over the
info icon.
-
The preview of entered date format will be displayed under the text box.
NOTE: Custom Format is visible only for Date Time, Date, Year and Date Hour.
The supported custom format types are provided in the following table.
| Types | Custom Formats | description |
| Year | yy | Displays the year, from 00 to 99 |
| yyyy | Display the year as a four-digit number | |
| Month | MM | Display the month, from 01 through 12 |
| MMM | Display the abbreviated name of the month | |
| MMMM | Display the full name of the month | |
| Hour | HH | Display the hour, using a 24-hour clock from 00 to 23 |
| hh | Display the hour, using a 12-hour clock from 01 to 12 | |
| Minute | mm | Display the minute, from 00 through 59 |
| Second | ss | Display the second, from 00 through 59 |
| Time | ttt | Display the AM/PM |
Fiscal Year Start
If you want to apply the custom format along with the fiscal year, use the Fiscal Year Start option from the Date Settings dialog as follows.
NOTE: Filtering operation won’t work when you are choosing the widget as a master where you are applying the Custom date format for the date column.