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 that controls the display format of the field, within the application.
VALUE_FORMAT is an optional 30-character alphanumeric field displaying user-defined code to uniquely identify the value format within the system.
At line 3 removed 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 changed 17 lines
||Input|| Format|| Output ||
|123456.789| ###,###.### |123,456.789| The pound sign (#) denotes a digit, the comma is a placeholder for the grouping separator, and the period is a placeholder for the decimal separator.
|123456.789| ###.## |23456.79 |The value has three digits to the right of the decimal point, but the pattern has only two. The format method handles this by rounding up.
|123.78|000000.000| 00123.780 |The pattern specifies leading and trailing zeros, because the 0 character is used instead of the pound sign (#).
|12345.67| $###,###.### |$12,345.67 |The first character in the pattern is the dollar sign ($). Note that it immediately precedes the left most digit in the formatted output.
\\ \\
For Date fields, the following characters may be used (case is very important here, the wrong case will give invalid results or errors)
||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
|EEE |Day | Used to display different formats for the Day of the Week\\E = 2 (single digit day of week)\\ EE = 02 (two-digit day of week) \\EEE = Tue (3-letter abbreviation of the literal representation of the day of week)\\ EEEE = Tuesday (full day of week name)
~* 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"
[{If var='loginstatus' contains 'authenticated'
At line 31 removed 8 lines
\\ \\
Time values may be formatted as
||h ||Hour || h or hh gives 1 or 01
|mm |Minute |
|ss |Seconds |
|a |AM/PM |
At line 40 changed 2 lines
![Notes|Edit:Internal.VALUE_FORMAT]
[{InsertPage page='Internal.VALUE_FORMAT' default='Click to create a new notes page'}]
![Discussion|Edit:Internal.VALUE_FORMAT]
[{InsertPage page='Internal.VALUE_FORMAT' default='Click to create a new discussion page'}]
}]
This page (revision-9) was last changed on 26-Nov-2021 10:22 by kparrottTop