Configure the Display Format property for fields
- Last UpdatedApr 10, 2025
- 3 minute read
Most fields in a project have a DisplayFormat property. This value specifies the formatting of numeric data types: Date, Double, Integer, Long, and Single.
For each different numeric data type there is a default format; for example, 0.######.
|
Format specifier |
Name |
Description |
Examples |
|---|---|---|---|
|
"0" |
Zero placeholder |
Replaces the zero with the digit that corresponds if one is present; otherwise, zero appears in the result string. |
1234.5678 ("00000") -> 01235 0.45678 ("0.00", en-US) -> 0.46 0.45678 ("0.00", fr-FR) -> 0,46 |
|
"#" |
Digit placeholder |
Replaces the "#" symbol with the digit that corresponds if one is present; otherwise, no digit appears in the result string. |
1234.5678 ("#####") -> 1235 0.45678 ("#.##", en-US) -> .46 0.45678 ("#.##", fr-FR) -> ,46 |
|
"." |
Decimal point |
Determines the location of the decimal separator in the result string. |
0.45678 ("0.00", en-US) -> 0.46 0.45678 ("0.00", fr-FR) -> 0,46 |
|
"," |
Group separator and number scaling |
Serves as both a group separator and a number scaling specifier. As a group separator, it inserts a localized group separator character between each group. As a number scaling specifier, it divides a number by 1000 for each comma specified. |
Group separator specifier: 2147483647 ("##,#", en-US) -> 2,147,483,647 2147483647 ("##,#", es-ES) -> 2.147.483.647 Scaling specifier: 2147483647 ("#,#,,", en-US) -> 2,147 2147483647 ("#,#,,", es-ES) -> 2.147 |
Value passed through Production Analyst
|
Specifier |
Type |
Example Output(Passed Double 1.42) |
Example Output(Passed Int -12400) |
|---|---|---|---|
|
c |
Currency |
$1.42 |
-$12,4000 |
|
d |
Decimal (Whole number) |
System Format Exception |
-12400 |
|
e |
Scientific |
1.420000e+000 |
-1.240000e+004 |
|
f |
Fixed point |
1.42 |
-12400.00 |
|
g |
General |
1.42 |
-12400 |
|
n |
Number with comma for thousands |
1.42 |
-12,400 |
|
r |
Round trip |
1.42 |
System.Format.Exception |
|
x |
Hexadecimal |
System.Format.Exception |
cf90 |
|
p |
Percentage |
1.42% |
-12,400.00% |
Value passed through Web Services
Percentage - The Web Service does not use the display format when data is submitted. When the DisplayFormat property for a field has a specifier of p, and 1.42 is passed through Web Services, the output is 142%.
For more information on custom numeric format strings, see http://msdn.microsoft.com/en-us/library/0c899ak8.aspx.
Date and time formats
Standard date and time formats
|
Specifier |
Type |
Example Output (Passed Fri 08/01/2018 1:53:19PM) |
|---|---|---|
|
d |
Short date pattern |
08/01/2018 |
|
D |
Long date pattern |
Monday, 08 January, 2018 |
|
f |
Full date/time pattern (short time) |
Monday, 08 January, 2018 1:53 PM |
|
F |
Full date/time pattern (long time) |
Monday, 08 January, 2018 1:53:19 PM |
|
M, m |
Month/day pattern |
08 January |
|
Y, y |
Year month pattern |
January, 2018 |
For more information on standard date and time format strings, see https://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.110).aspx.
Custom date and time formats
|
Specifier |
Type |
Example Input |
Example Output |
|---|---|---|---|
|
d |
The day of the month from 1 through 31 |
Mon 08/01/2018 1:53:19PM |
8 |
|
dd |
The day of the month from 1 through 31 |
Mon 08/01/2018 1:53:19PM |
08 |
|
h |
The hour, using a 12-hour clock from 1 to 12. |
Mon 08/01/2018 1:53:19PM |
1 |
|
hh |
The hour, using a 12-hour clock from 01 to 12. |
Mon 08/01/2018 1:53:19PM |
01 |
|
H |
The hour, using a 24-hour clock from 0 to 23. |
Mon 08/01/2018 1:53:19PM |
13 |
|
HH |
The hour, using a 24-hour clock from 00 to 23. |
Mon 08/01/2018 1:53:19PM |
13 |
|
m |
The minute, from 0 through 59. |
Mon 08/01/2018 1:53:19PM |
53 |
|
mm |
The minute, from 0 through 59. |
Mon 08/01/2018 1:53:19PM |
53 |
|
M |
The month, from 1 through 12. |
Mon 08/01/2018 1:53:19PM |
1 |
|
MM |
The month, from 1 through 12. |
Mon 08/01/2018 1:53:19PM |
01 |
For more information on custom date and time format strings, see https://msdn.microsoft.com/en-us/library/8kb3ddd4(v=vs.110).aspx
Display appearance in Production Analyst results grid
Most numeric data types will display in the Production Analyst grid as right-aligned, except for certain exceptions.
This table lists the exceptions to right-alignment for numerics.
|
Exceptions to Numeric right-alignment |
|
|---|---|
|
Module |
Field name |
|
Inventory |
Movement Type Movement Direction AdjustmentType AdjustmentMethod LotBehavior |
|
Downtime |
Cause Effect Classification |