Formatting Date and Time Fields

You can change the format of the date and time values that are displayed in your visuals.
To format date and time fields:
  1. Click Dashboards tab, the Dashboards tab.
  2. Click Dashboard Designer, in the bottom-left corner.
  3. On the Analyses dialog, click Options button, the Options button, next to an existing analysis and select Edit.
  4. On the analysis page, select a visual.
  5. Click Visualize button, the Visualize button, on the toolbar to display the Visuals panel.
  6. In the Visuals panel, click Options button, the Options button, next to a date field and select Format ⇒ More Formatting Options.
    You can also select one of the common formatting options available directly from the Format list.
  7. In the Format data panel, configure formatting settings for displaying date, time, and null values.
    1. Expand the Date section and select a date format.
      If you select Custom, you must specify a format pattern in the Custom section lower down in the Format data panel. If you use Custom for the date format, you must also use Custom for the time format.
    2. Expand the Time section and select a time format.
      If you select Custom, you must specify a format pattern in the Custom section lower down in the Format data panel. If you use Custom for the time format, you must also use Custom for the date format.
    3. If you selected Custom in the Date and Time sections, expand the Custom section and specify the format pattern that you want to use.
      The default format pattern is MMM D, YYYY h:mma, for example Sep 20, 2024 5:30pm.

      If you selected one of the predefined formats in the Date and Time sections, the Custom section displays the format pattern that matches your selection. For example, if you chose Jun 21, 2024 in the Date section and 17:00:00pm in the Time section, the Custom section shows the format pattern MMM D, YYYY H:mm:ssa.

    4. Expand the Null values section and specify whether to display null values as null or as a custom value.
    To set the format based on the language setting, click Apply language format at the bottom of the Format data panel.

In this section:

  1. Custom Date and Time Formats
    You can customize how date and time values are formatted in your filter and parameter controls using a combination of supported tokens. For example, you can format the date as Sep 20, 2024 or as 09-20-2024.
Parent topic: Formatting Fields