This page (revision-9) was last changed on 26-Nov-2021 10:22 by kparrott

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
9 26-Nov-2021 10:22 2 KB kparrott to previous
8 26-Nov-2021 10:22 2 KB kparrott to previous | to last
7 26-Nov-2021 10:22 2 KB jaiken to previous | to last
6 26-Nov-2021 10:22 2 KB rforbes to previous | to last
5 26-Nov-2021 10:22 2 KB RForbes to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB RForbes to previous | to last
2 26-Nov-2021 10:22 1 KB RForbes to previous | to last
1 26-Nov-2021 10:22 353 bytes JMyers to last

Page References

Incoming links Outgoing links
VALUE_FORMAT
VALUE_FORMAT

Version management

Difference between version and

At line 1 changed one line
VALUE_FORMAT is an optional 30-character alphanumeric field displaying user-defined code to uniquely identify the value format within the system.
VALUE_FORMAT is an optional 30-character alphanumeric field that controls the display format of the field, within the application.
At line 3 added 9 lines
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
At line 13 added 13 lines
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"
This page (revision-9) was last changed on 26-Nov-2021 10:22 by kparrottTop