Contact Support
Custom Date/Time/Datetime Formatting
You can customize the display format of dates in dashboard widgets based on your need. You can choose from the wide range of date formats available including, custom date format.
How to format the Date field value shown in the Widgets
Bind the date field to the widget as shown in the image below.
Click on the settings
button in the added field.
Format option is provided in the context menu. Click on the Settings
menu item to open the window.
Date Settings
window will be opened as shown here:
Format
shows the predefined available options provided for the selected date/time format.
For example,
If Year is selected, then the following options will be shown.
Select the formatting option you want; it will be reflected in the widget.
For example, if we select 16,17,...
option then the widget will be rendered like shown in the below image:
You can find the predefined formats in the below table.
</table> N> Date time formatting option is not available for the `Time`,`Week Year`,`Day Month Year`, `Month Day Year` types. N> N> Also, the date/time formatting option is not available for the `Chart` and `Range navigator` widget types. ## Custom formatting the date time format Select the `custom` option in the format window.  Now the `Custom Format` text box will be enabled.  Specify the custom format in the textbox and hit `OK` button.  Widget will be re-rendered like shown here:  **Proper custom date time format**: An example date time value will appear in the preview area as per the date time format specified in the textbox.  **Invalid format**: For invalid date formats, it will show the below alert message:  The list of valid format specifiers can be referred from table mentioned in this [page](https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx) You can find the formatting strings by hovering the `i` icon in the format window.  The valid format strings are listed in the below table.Type | Formats available |
---|---|
Year |
|
Quarter |
|
Month |
|
Hour |
|
Minutes |
|
Seconds |
|
Quarter Year |
|
Month Year |
|
Date Hour |
|
Week of Year |
|
Day |
|
Format String | description |
---|---|
yy | Displays the year, from 00 to 99. |
yyyy | Display the year as a four-digit number. |
MM | Display the month, from 01 through 12. |
MMM | Display the abbreviated name of the month |
MMMM | Display the full name of the month. |
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. |
mm | Display the minute, from 00 through 59. |
ss | Display the second, from 00 through 59. |
ttt | Display the AM/PM. |