A script-enabled browser is required for this page to function properly.

Format Mask property

The Format Mask property specifies how to display Date and Number values in the field. You can enter custom masks for numbers and dates or you can select from the list of values. Character values have no format mask. See Date and time format mask syntax and Number format mask syntax for the correct syntax.

The values displayed initially in the list are determined by the Datatype of the field (for example, for a field of Datatype Number, only number masks are shown in the list). If you enter a mask not in the list for Format Mask and close the Field Property Inspector, the new format mask will appear in the list of values.

Applies to

Fields

Values

A valid date or number mask, not to exceed 1K.

Default

Blank

Required/Optional

Optional

PL/SQL procedure

SRW.SET_FORMAT_MASK

Restrictions

Usage notes

Value     Width of    Output 
           Source    Displayed

 9.99999     4         10.0
9.99999 3 10.
9.99999 2 10
9.99999 1 *
-9.99999 4 -10.
-9.99999 3 -10
-9.99999 2 **
400 2 **
4.563 5 4.563
4.563 4 4.56
4.563 3 4.6
0.001 5 .001
0.001 4 .001
0.001 3 .00
0.001 2 .0
0.001 1 .
-0.01 4 -.01
-0.01 3 -.0
-.01 2 -.

Examples

  Sample Date Format          Date Displayed

MM/DD/RR                     03/04/85
DD MON RRRR 04 MAR 1985
Mon. DD, RRRR Mar. 4, 1985
Day Month DD fmHH:MI AM Monday March 4 11:35 AM
Dy Mon ddth fmHH24:MI:SS Mon Mar 4th 23:35:22
Day :the" ddthsp "of" Month Monday the fourth of March

Sample Number   Number        Number 
   Format                   Displayed

-0000            7934         "7934"
                -7934         "-7934"

-00000           7934         "07934"

-NNNN            7639         "7639"
                  535         "535"

-NNN             7639         "****"

-****            7902         "7902"

-*****           7902         "*7902"

+NNNN             100         "+100"
                  -99         "-99"

(NNNN)           1600         " 1600 "
                 -800         "(800)"

NNNNPR           1600         " 1600 "
                 -800         "<800>"

NNNNMI           1600         "1600 "
                 -800         "800-"

NNNVNN            343         "34300"

N.NNEEEE         7369         "7.37E+03"

"SRW"-0000       7782         "SRW7782"

-$NNNN.NN         800         "$800"
                 1600         "$1600"

-%NNN              10         "%10"

-NN NNN.NN       3000         "3 000"

+KKNNNNN.00      1950         "+  1950.00"
                  900         "+   900.00"

$<NNNNN.00>      1200         "$  1200.00"
                  500         "$   500.00"

$<NNNNN.00> DB   1200         "   1200.00  DB"
                 -500         "$   500.00"

$<NNNNN.00> CR   1200         "$  1200.00"
                 -500         "$   500.00 CR"

* The quotation marks will not appear in your output. They are used here to make it clear where there are leading or trailing spaces.