Display date only on column instead of date/time

Contents[Hide]

1. Overview

For a date/time data type, you have the option of changing the display of the column to show the date portion only instead of both date and time.

Table Before Editing
Table Before Editing

2. Change from Date/Time Format to Date Format

On the dashboard, select the table, and go to Properties. Go to Main > Table > <date_name> column.

Table Properties
Table Properties

Go to the Text tab.

Under Rows, 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 Format
Custom Text Format

Enter a keyword that includes a colon after the element name followed by a format, for example: [<date_name>: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.

Typing the date format for the column
Typing the 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