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.

The Rows > Text property is read-only and shows the name of metric set element that this column is connected to.

Go to Rows > Custom Text. Click the plus sign under Custom Text.

Custom Text Format
Custom Text Format

Type in [<date_name>:MM/dd/yyyy] in the custom text. It should change the format of the date column.

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

3. Other Date Format Settings

You can also use other date format strings in the column. See Formatting Text for more details.

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

4. 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