Custom Web Publishing Guide

74 FileMaker Server Advanced Custom Web Publishing Guide
Pattern letters are usually repeated, as their number determines the exact presentation:
1 Text: For formatting, if the number of pattern letters is four or more, the full form is used; otherwise a
short or abbreviated form is used if available. For parsing, both forms are accepted, independent of the
number of pattern letters.
1 Number: For formatting, the number of pattern letters is the minimum number of digits, and shorter
numbers are zero-padded to this amount. For parsing, the number of pattern letters is ignored unless it’s
needed to separate two adjacent fields.
1 Year: For formatting, if the number of pattern letters is two, the year is truncated to two digits; otherwise
it is interpreted as a number.
For parsing, if the number of pattern letters is more than 2, the year is interpreted literally, regardless of
the number of digits. So using the pattern “
MM/dd/yyyy”, “01/11/12” parses to Jan 11, 12 A.D.
For parsing with the abbreviated year pattern (“y” or “yy”), the abbreviated year must be interpreted
relative to some century by adjusting dates to be within 80 years before and 20 years after the time the
date format instance is created. For example, using a pattern of “
MM/dd/yy” and a date format instance
created on Jan 1, 1997, the string “01/11/12” would be interpreted as Jan 11, 2012 while the string “05/
04/64” would be interpreted as May 4, 1964. During parsing, only strings consisting of exactly two digits
will be parsed into the default century. Any other numeric string, such as a one digit string, a three or
more digit string, or a two digit string that isn’t all digits (for example, “
-1”), is interpreted literally. So
“
01/02/3” or “01/02/003” are parsed, using the same pattern, as Jan 2, 3 AD. Likewise, “01/02/-3” is parsed
as Jan 2, 4 BC.
F Day of week in month Number 2
E Day in week Text Tuesday; Tue
a Am/pm marker Text PM
H Hour in day (0-23) Number 0
k Hour in day (1-24) Number 24
K Hour in am/pm (0-11) Number 0
h Hour in am/pm (1-12) Number 12
m Minute in hour Number 30
s Second in minute Number 55
S Millisecond Number 978
z Time zone General time zone Pacific Standard Time; PST; GMT-
08:00
Z Time zone RFC 822 time zone -0800
Letter Date or Time Component Presentation Examples