Date/Time Display Formats

Arcadia Data enables you to specify date/time display formats for a numerical field by selecting from a number of common formats, or by specifying a custom format.

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. Make a selection from one of the Basic Formats. These include most common forms, such as 2010-01-05, 01/05/2010, 1/5/10, Jan 05, 2010, Friday, January 5th, 2010, 10-Jan-05, Q1 2010, 1:05 pm, 01:05:53 PM, 13:05:53.010, 1/5/10 1:05:53 PM, and 01/05/2010 13:05:53.

    Alternatively, specify select the Custom Date Format option in the Basic Formats menu, and then use the Customize Date/Time text filed to enter the custom format.

    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. In the Basic Formats menu, select Custom Date Format.
  5. Click Refresh Visual.
  6. Notice the change to the number format in column pickup_datetime.

    custom format applied