Arcadia Enterprise 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:
Under Field Properties, click the Display Format option.
In the Display Format interface, select Date/Time from the Category menu.
Either make a selection in the Basic Formats menu, or enter a valid format mask in the Customize Date/Time text box.
Click Save.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
.
pickup_neighborhood
on the Dimensions
shelf, and the field pickup_datetime
on the
Measures shelf.pickup_datetime
field by selecting the mask
2010-01-05 from the Basic Formats menu of the
Display Format: Date/Time interface.Notice the change to the number format in column pickup_datetime.
pickup_neighborhood
on the
Dimensions shelf, and the field pickup_datetime
on the Measures shelf.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.Notice the change to the number format in column pickup_datetime.