Wiki: VALUE

VALUE_FORMAT is an optional 30-character alphanumeric field that controls the display format of the field, within the application.

For Numeric Fields, the following characters may be used

Char	Location	Meaning
0	in the Number	Digit
#	in the Number	Digit, zero shows as absent
.	in the Number	Decimal separator or monetary decimal separator
-	in the Number	Minus sign
,	in the Number	Grouping separator
;	Subpattern boundary	Separates positive and negative subpatterns
%	Prefix or suffix	Multiply by 100 and show as percentage

For Date fields, the following characters may be used

Letter	Component	Examples
y	Year	yy or yyyy gives 96 or 1996
M	Month	MM will give a 2 digit month, more than 2 M's will give a text name (MMM = Jul) Note:mm is minutes
w *	Week in year	ww would return a number from 01-53
W *	Week in Month	W would return a number from 1-5
D *	Day in year	DDD would give the day of the year (001-366)
d *	Day in month	dd would give the day of the month (01-31)
F	Day of week in month	F would give a number from 1-7
E	Day	Providing more than 4 Es would give full name (i.e Tuesdy)

Format characters indicated show the minimum number of digits to be shown. For example, If the Day of the Year is 6, a format of D would give "6", but DD would give "06" and DDD would give "006"

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor