Please enable JavaScript to view this site.

AudienceView Unlimited 7  Product Guides

Navigation: Registry > System Settings

Date & Time Display Formats

Scroll Previous Top Next More

You can change the format used to display dates and times. The default date format is YYYY-MM-DD. Changing the default date format will be used across all applications including Desktop, online, 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.

info_outline

Information

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 events, you could modify the 'Subtype' of the Registry - 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

Events

To define the default date and time format:

1.Define the default date and time format within the Registry.

2.Define the Windows date and time format on the application server.

info_outline

Information

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 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/2024 which could be January 2, 2024 or February 1, 2024. If the Windows setting is MM/DD/YYYY and the Registry setting is DD/MM/YYYY, the date 01/02/2024 will be considered MM/DD/YYYY not DD/MM/YYYY as expected.

The date/time format dd-mm-yyyy HH:SS will return 09-12-2024 19:02 for nl_NL and en_US; however, if a long form date component is requested (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 Date and Time Display 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 Date and Time Display Formats and Date and Time Format Settings.

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

Date and Time Display Formats

Date and Time Criteria

Default Date and Time Format

Date Format Codes

Date and Time Subtypes
Describes the date/time subtypes that can be formatted and applied to nodes to define different date and time settings.

Date and Time Format Settings
Describes the various Business Objects and Collection Objects where different date/time subtypes are commonly applied in the Registry.

Windows Date and Time Settings