Adjust the Display Format of Date or Time Columns

You can adjust the display format of a date or a time column by specifying the format and the level of granularity.

For example, you might want to change the format of a transaction date column (which is set by default to show the long date format such as November 1, 2017) to display instead the International Standards Organization (ISO) date format (such as 2017-11-01). You might want to change the level of granularity (for example year, month, week, or day).
  1. Open the project or the data set that includes the date and time column that you want to update. If you’re working in a project, then confirm that you’re working in the project's Prepare canvas.
  2. Click the date or time column you want to edit.
    For example, click a date in the data elements area of the Data Panel, or click or hover over a date element on the main editing canvas.
  3. If you’re working in the main editing canvas, adjust the format by doing one of the following:
    • Click Options, then Extract to display a portion of the date or time (for example, the year or quarter only).

    • Click Options, then Edit to display an Expression Editor that enables you to create complex functions (for example, with operators, aggregates, or conversions).

    • In the properties pane, click the Date/Time Format tab, and use the options to adjust your dates or times (for example, click Format) to select from short, medium, or long date formats, or specify your own format by selecting Custom and editing the calendar string displayed.

  4. If you’re working in the data elements area of the Data Panel, adjust the format by doing one of the following:
    • If you want to display just a portion of a calendar column (for example, the year or quarter only), then select and expand a calendar column and select the part of the date that you want to display in your visualization. For example, to only visualize the year in which orders were taken, you might click Order Date and select Year.
    • In the properties pane, click the Date/Time Format tab, and use the options to adjust your dates or times.
  5. If you’re working in table view, select the column header and click Options, then in the properties pane click Date/Time Format to display or update the format for that column.