Date/Time Display Formats

Arcadia Instant offers common notation options for formatting Date/Time fields. It also offers a simple customization component that transforms date/time information.

By default, data/time records appear in the form [YYYY]-[MM]-[DD] [hh]:[mm]:[ss].[sss], in most-to-least significant order. This is consistent with the ISO 8601 Date and Time Specification.

The following steps demonstrate how to adjust the display format for date/time fields:

  1. Click on the field you plan to modify, to open the Field Properties menu.
  2. Under Field Properties, click the Display Format option.

  3. In the Display Format interface, select Date/Time from the Category menu.

  4. Either make a selection in the Basic Formats menu, or enter a valid format mask in the Customize Date/Time text box.

    Click Save.
    display format in Date/Time mode
  5. Click Refresh Visual.

The following examples demonstrate the use of date/time display formatting interface for Basic Formats for Date/Time and Custom Formats for Date/Time. We are using the NYC Taxicab Rides Detail dataset, based on the table main.trips-detail.

Basic Formats for Date/Time

  1. Create a new Table visual on the NYC Taxicab Rides Detail dataset.
  2. Place the field pickup_neighborhood on the Dimensions shelf, and the field pickup_datetime on the Measures shelf.
  3. Change the format display for pickup_datetime field by selecting the mask 2010-01-05 from the Basic Formats menu of the Display Format: Date/Time interface.
  4. Click Refresh Visual.
  5. Notice the change to the number format in column pickup_datetime.

    basic format applied

Custom Formats for Date/Time

  1. Create a new Table visual on the NYC Taxicab Rides Detail dataset.
  2. Place the field pickup_neighborhood on the Dimensions shelf, and the field pickup_datetime on the Measures shelf.
  3. Change the format display for pickup_datetime field by entering the mask hh:mm aselecting the mask 2010-01-05 under the Customize Date/Time option of the Display Format: Date/Time interface.
  4. Click Refresh Visual.
  5. Notice the change to the number format in column pickup_datetime.

    custom format applied