Display Format Property of a Control or List Column

The following table describes values for the Display Format property of a control or list column.

Property Description

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:

  • MM/DD/YY

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.