Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
- Valid mask characters
- Valid mask characters are
Y (year),
M (month),
D (day), and special characters.
- Default input and output format
- MM.DD.YY The field length determines if the special characters are assigned. For example, if you select the
MM/DD/YY format, and the field length is 8, then AMB assigns
MM/DD/YY to the field; if the field length is 6, AMB assigns
MMDDYY to the field.
- Restrictions
-
- Y
-
- 2 or 4 characters
- 2
Ys indicate a numeric year, such as 14
- 4
Ys indicate a numeric century and year, such as 2014
- M
-
- 2, 3, or 9 characters
- 2
Ms indicate a numeric month, such as 12
- 3
Ms indicate a short character month, such as DEC
- 9
Ms indicate a long character month, such as DECEMBER
- D
-
- 3 characters if you do not define Month, otherwise it must be 2 characters
- 2
Ds indicate a numeric Gregorian day, such as 30
- 3
Ds indicate a numeric Julian day, such as 360
Month, day, and year must be in the same order in both the input and output formats. For example:
| Storage Format
|
YYYYMMDD
|
| Input Format
|
MMDDYY
|
| Output Format
|
MMMMMMMMM DD, YYYY
|