Previous Topic Next topic Print topic


Date Field Formats

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
Previous Topic Next topic Print topic