Defining Display Profiles

When you set up your users, you reference a display profile. A user's display profile controls how dates, times, and numbers displayed. Choose Admin > General > Display Profile > Search to maintain display profiles.

Description of Page

Enter a unique Display Profile ID and Description to identify the profile.

Enter a Date Format. This affects how users view dates and how entered dates are parsed. This is a "free format" field with some rules.

Here are some examples of date formats.

Format Displayed / entered as
MM-dd-yyyy 04-09-2001
d/M/yyyy 9/4/2001
yy.MM.dd 01.04.09
MM-dd-y 04-09-01 - in this case you could also enter the date as 04-09-2001
Note: For centuries, the default pivot for 2-digit years is 80. Entry of a 2-digit year greater than or equal to 80 results in the year being interpreted as 19xx. Entry of a 2-digit year less than 80 results in the year being interpreted as 20xx.

In addition, the following date localization functionality is supported. Note that in every case, the date is stored in the database using the Gregorian format. The settings below result in a conversion of the date for the user interface.

Enter a Time Format. This is a "free format" display with some rules.

Here are some examples of time formats.

Format Displayed / entered as
hh:mma 09:34PM (can be entered as 09:34p)
hh:mm:ss 21:34:00
h:m:s 9:34:0

There are several options for displaying Numbers.

Decimal Symbol defines the separator between the integer and decimal parts of a number. Valid values are "." (a period) or "," (a comma),

Group Symbol defines the means to separate groups of bigger numbers. Valid values are

Negative Format defines how negative values are displayed. Valid values are -9.9, (9.9), or 9.9-.

Currency values can have a different Negative Format from other numbers. Valid values are -S9.9, (S9.9), or S9.9-, where the "S" represents the currency symbol.

Where Used

Follow this link to open the data dictionary where you can view the tables that reference CI_​​DISP_​​PROF.