AudienceView Connect
AudienceView Documentation

Defining the Default Date and Time 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 level 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 Start Date within TSperformanceCO to change the date format.

At the Business Object and Collection Object level, the date formatting options are controlled using the dateFormats list. If the desired date format is not available, you can modify this list to include the desired option.

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

  • Price Charts
  • Performances
  • Series

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 within the Registry.
  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.