2022.1

Date and time patterns
Dates and times in a template originating from a date field in a record set can be displayed
using a custom pattern. In the Script Editor, the pattern can be passed to a date, dateTime or
Time function of the formatter; see "formatter" on page803.
The custom pattern may consist of pattern letters (see below), for example: "MM/dd/yyyy". The
components can be separated with a space or a symbol, e.g. ., /, -. Text must be put in quotes.
The repetition of pattern letters determines the exact presentation. For example, if the number of
pattern letters for a month is less than 3 (M or MM), the month is displayed as a number. If the
number of pattern letters is 3 (MMM), it will be displayed as text; if available, a short or
abbreviated form of the month's name will be used. If the number of pattern letters is 4 or more
(MMMM), the month's full name is displayed.
Note
The pattern letters and patterns on this page are only suitable for displaying dates and
times in templates.
Pattern characters
Letter Component Presentation Examples
G Era designator Text AD
y Year Year 1996; 96
Y Week year Year 2009; 09
M Month in year Month July; Jul; 07
w Week in year Number 27
W Week in month Number 2
D Day in year Number 189
d Day in month Number 10
F Day of week in month Number 2
E Day name in week Text Tuesday; Tue
u
Day number of week (1 = Monday, ..., 7
= Sunday)
Number 1
a Am/pm marker Text PM
Page 809