Configuring Siebel Business Applications > Reference Materials for Configuring Siebel Business Application > Properties of Object Types >
Display Format Property of a Control or List Column
Table 89 describes values for the Display Format property of a control or list column.
Table 91. Values for the Display Format Property of a Control or List Column
|
|
DTYPE_NUMBER |
Can include the following values:
- 0 (zero)
- # (pound sign)
- + (plus sign)
- - (minus sign)
- , (comma)
- . (period)
If empty, then to determine the appearance of numeric values, Siebel CRM uses the Regional Settings section of the Windows Control Panel. |
DTYPE_CURRENCY |
Uses the same symbols as with the DTYPE_NUMBER property, in addition to the dollar sign. To control how Siebel CRM displays currency, in the Siebel client, you navigate to the Application Administration screen, choose the Currencies view, and then modify the Scale field. |
DTYPE_DATETIME |
Stores one of the following values in the Display Format property:
- Date
- DateTime
- DateTimeNoSec
- TimeNoSec
|
DTYPE_DATE |
Uses a combination of the following values:
where:
- MM is the month.
- DD is the day.
- YY is the year.
If empty, then to determine the appearance of date values, Siebel CRM uses the Regional Settings section of the Windows Control Panel. For more information, see How Siebel CRM Handles Certain Date Formats. |
DTYPE_TIME |
You can use one of the following formats:
- Specify TimeNoSec.
- Specify a format mask using a combination of the following values:
- HH:hh:mm:ss
where:
- HH is the hours.
- hh is the hours.
- mm is the minutes.
- ss is the seconds.
If empty, then to determine the appearance of time values, Siebel CRM uses the Regional Settings section of the Windows Control Panel. |
DTYPE_PHONE |
If empty, then to determine the appearance of phone values, Siebel CRM uses the Regional Settings section of the Windows Control Panel. |
How Siebel CRM Handles Certain Date Formats
If you set DDD, DD/MM/YYYY as the display format on a date list column, then Siebel CRM displays the date with the expected format but you cannot update the date. If you attempt to update the date, then it displays an error that is similar to the following: Can't convert formatted string to its internal representation. Please check if your data is in correct format.
The same situation occurs if you use the DDD/MM/YYYY format.
|