Display date only on column instead of date/time

Contents[Hide]

1. Overview

Visualizations include the ability to change the format of dates and other values.

For example, you have the option of changing a table column to show only the date portion instead of both date and time.

Note
You can also use a time dimension hierarchy with your column at the Day level or higher. For an example of using time dimensions, see View data with a chart and drill down.

Table before editing
Table before editing

2. Changing the format

On the dashboard, select the table, and go to Properties. In the Main tab, click to edit your column's properties.

Column properties
Column properties

In the Text tab under Rows, notice the Text property is read-only and shows the name of the metric set element that this column displays.

Click the + button under Custom Text.

Custom text property
Custom text property

Enter the keyword for your date element, and edit it to include a colon after the element name followed by a format. For example: [Date:MM/dd/yyyy].

Typing the date format for the column
Typing the date format for the column

See Formatting text for more details about keywords and their formatting options.

A different date format for the column
A different date format for the column

3. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri