Predefined Display Formats
Alpha Five uses display formats to present data in form fields.
|
Category |
Code |
Description/Example |
|
Character |
"" |
None |
|
"C" |
Uppercase | |
|
"L" |
Lowercase | |
|
"F" |
First letter uppercase and remainder of the string unchanged. | |
|
"W" |
First letter of each word uppercase and remainder of word unchanged. | |
|
"Y" |
First letter uppercase and remainder of the string lower case. | |
|
"Z" |
First letter of each word uppercase and remainder of word lowercase. | |
|
Numeric |
"" |
None |
|
"B" |
1234567.78 (blank if zero) | |
|
"$(" |
$123,456.78 | |
|
"," |
123,456.78 | |
|
"%" |
123,456.78% | |
|
"XF" |
Fifty six and 78/100 | |
|
"XF$" |
Fifty six and 78/100 Dollars | |
|
"$(B" |
$123,456.78 (blank if zero) | |
|
",B" |
123,456.78 (blank if zero) | |
|
"%B" |
123,456.78% (blank if zero) | |
|
"XBF" |
Fifty six and 78/100 (blank if zero) | |
|
"X$(BF" |
Fifty six and 78/100 Dollars (blank if zero) | |
|
"$(*" |
***$123,456.78 (right justified and padded with asterisks) | |
|
",*" |
***123,456.78 (right justified and padded with asterisks) | |
|
"X*F" |
***Fifty six and 78/100 (right justified and padded with asterisks) | |
|
"X$*F" |
***Fifty six and 78/100 Dollars (right justified and padded with asterisks) | |
|
"$(B*" |
***$123,456.78 (blank if zero, right justified and padded with asterisks) | |
|
",B*" |
***123,456.78 (blank if zero, right justified and padded with asterisks) | |
|
"XB*F" |
***Fifty six and 78/100 (blank if zero, right justified and padded with asterisks) | |
|
"X$(B*F" |
***Fifty six and 78/100 Dollars (blank if zero, right justified and padded with asterisks) | |
|
"XC" |
FIFTY SIX AND 78/100 | |
|
"X$(C" |
FIFTY SIX AND 78/100 DOLLARS | |
|
"XBC" |
FIFTY SIX AND 78/100 (blank if zero) | |
|
"X$(BC" |
FIFTY SIX AND 78/100 DOLLARS (blank if zero) | |
|
"X*C" |
***FIFTY SIX AND 78/100 (right justified and padded with asterisks) | |
|
"X$(*C" |
***FIFTY SIX AND 78/100 DOLLARS ( right justified and padded with asterisks) | |
|
"XB*C" |
***FIFTY SIX AND 78/100 (blank if zero, right justified and padded with asterisks) | |
|
"X$(B*C" |
***FIFTY SIX AND 78/100 DOLLARS (blank if zero, right justified and padded with asterisks) | |
|
"XL" |
fifty six and 78/100 | |
|
"X$(L" |
fifty six and 78/100 dollars | |
|
"XBL" |
fifty six and 78/100 (blank if zero) | |
|
"X$(BL" |
fifty six and 78/100 dollars (blank if zero) | |
|
"X*L" |
***fifty six and 78/100 | |
|
"X$(*L" |
***fifty six and 78/100 dollars | |
|
"X*BL" |
***fifty six and 78/100 (blank if zero) | |
|
"X$(B*L" |
***fifty six and 78/100 dollars (blank if zero) | |
|
"XW" |
Fifty Six And 78/100 | |
|
"X$(W" |
Fifty Six And 78/100 Dollars | |
|
"XBW" |
Fifty Six And 78/100 (blank if zero) | |
|
"X$(BW" |
Fifty Six And 78/100 Dollars (blank if zero) | |
|
"X*W" |
***Fifty Six And 78/100 (right justified and padded with asterisks | |
|
"X$(*W" |
***Fifty Six And 78/100 Dollars (right justified and padded with asterisks | |
|
"XB*W" |
***Fifty Six And 78/100 (blank if zero, right justified and padded with asterisks) | |
|
"X$(B*W" |
***Fifty Six And 78/100 Dollars (blank if zero, right justified and padded with asterisks) | |
|
Date |
"" |
None |
|
"1-" |
12-31-1998 | |
|
"2-" |
31-12-1998 | |
|
"1/" |
12/31/1998 | |
|
"2/" |
31/12/1998 | |
|
"3" |
31 December 1998 | |
|
"4" |
December 31, 1998 | |
|
"8" |
December 31st, 1998 | |
|
"5-" |
12-98 | |
|
"6-" |
12-31-98 | |
|
"7-" |
31-12-98 | |
|
"5/" |
12/98 | |
|
"6/" |
12/31/98 | |
|
"7/" |
31/12/98 | |
|
"9-" |
31-Dec-98 | |
|
"10" |
31 Dec 1998 | |
|
"11-" |
98-12-31 | |
|
"12-" |
1998/12/31 | |
|
"11/" |
98/12/31 | |
|
"12/" |
1998/12/31 | |
|
"11." |
98.12.31 | |
|
"12." |
1998.12.31 | |
|
"3C" |
31 DECEMBER 1998" | |
|
"4C" |
DECEMBER 31, 1998 | |
|
"8C" |
DECEMBER 31ST, 1998 | |
|
'9C" |
31-DEC-98 | |
|
"10C" |
31 DEC 1998 | |
|
Logical |
"" |
None |
|
"1" |
True/False | |
|
"2" |
Yes/No |
See Also
Date and Time Format Elements, Date and Time Functions