AudienceView Connect
AudienceView Documentation

Defining Date and Time Display Formats

You can change the format AudienceView uses to display dates and times if you have the permission to do so. The default date format is YYYY-MM-DD. Changing the default date format will be used across all AudienceView applications including Desktop, online sales, kiosk sales and access control. It is recommended that you only use numeric formats for displaying dates and times and avoid using abbreviations or full names of the day or month.

Some date and time formats displayed within the core reports are fixed and display YYYY-MM-DD or YYYY/MM/DD.

You can override the default date and time format at the Business Object or Collection Object levels to meet your needs. For example, if you want users to see the full name of the day and month when searching for performances, you could modify the 'Subtype' of the Registry application Registry::EN::Collection Objects::TSperformanceCO::Field::Start Date node to change the date format.

For more information regarding the Date/Time subtypes, refer to Date and Time Subtypes.

Once you change the date format, you should verify the date format displayed in the following areas:

  • Price Charts
  • Performances

To define the default date and time format, complete the following:

  1. Define the date and time format within the Registry.
    For more information, refer to Defining the Default Date and Time Format.
  2. Define the date and time format on the application server.
    For more information, refer to Changing Windows Date and Time Settings.
The date and time format defined for the application server (using Regional and Language Options in the Windows Control Panel) must match the date format defined in the AudienceView Registry. If the two do not match, the application will interpret ambiguous dates based on the Windows settings. An example of an ambiguous date is 01/02/2011 which could be January 2, 2011 or February 1, 2011. If the Windows setting is MM/DD/YYYY and the AudienceView setting is DD/MM/YYYY, the date 01/02/2011 entered in AudienceView will be considered MM/DD/YYYY not DD/MM/YYYY as expected.

The date/time format dd-mm-yyyy HH:MM will return 09-12-2013 19:02 for nl_NL and en_US; however, if a long form date component is requested (e.g. day of the week, month of year) the value will be returned using the language of the locale. For more information, refer to Defining the System Locale and Defining the Default Date and Time Formats.

There are a number of date/time subtypes available in the Registry that can each have their own formats. The subtypes can then be applied to the per instance primitive to replicate the previous per instance primitive formatting behaviour. For more information refer to Defining the Default Date and Time Formats and Date and Time Format Settings.

The following sections describe how to work with various display formats: