2021.1

Data format settings tell the DataMapper how to read and parse data from the data
source. They don't determine how these data are formatted in the Data Model or in a
template. In the Data Model, data are converted to the native data type. Dates, for
example, are converted to a DateTime object. How they are displayed in the Data Model
depends on the current operating system's regional settings..
Defining a date/time format
A date format is a mask representing the order and meaning of each digit in the raw data, as
well as the date/time separators. The mask uses several predefined markers to parse the
contents of the raw data. Here is a list of markers that are available in the DataMapper:
l yy: Numeric representation of the Year when it is written out with only 2 digits (i.e. 13)
l yyyy: Numeric representation of the Year when it is written out with 4 digits (i.e. 2013)
l M: Short version of the month name (i.e. Jan, Aug). These values are based on the
current regional settings.
l MM: Long version of the month name (i.e. January, August). These values are based on
the current regional settings.
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.
Page 290