2018.2

Table Of Contents
l
mm: Numeric representation of the month (i.e. 1, 09, 12)
l
D: Short version of the weekday name (i.e. Mon, Wed). These values are based on the
current regional settings.
l
DD: Long version of the weekday name (i.e. Monday, Wednesday). These values are
based on the current regional settings.
l
dd: Numeric representation of the day of the month (i.e. 1, 09, 22)
l
hh: Numeric representation of the hours
l
nn: Numeric representation of the minutes
l
ss: Numeric representation of the seconds
l
ms: Numeric representation of the milliseconds.
l
ap: AM/PM string.
l In addition, any constant character can be included in the mask, usually to indicate
date/time separators (i.e. / - :) . If one of those characters happens to be one of the
reserved characters listed above, it must be escaped using the \ symbol.
Note
The markers that can be used when extracting dates are different from those that are
used to display dates in a template (see the Designer's "Date and time patterns" on
page1146).
Examples of masks
Value in raw data Mask to use
June 25, 2013 MM dd, YYYY
06/25/13 mm/dd/yy
2013.06.25 yyyy.mm.dd
2013-06-25 07:31 PM yyyy-mm-dd hh:nn ap
2013-06-25 19:31:14.1206 yyyy-mm-dd hh:nn:ss.ms
Page 235