2020.2

l In the user preferences ("DataMapper preferences" on page829).
l In the data source settings ("Data source settings" on page222).
l
In the field properties: on the Step properties pane, under Data Format, specify the
Date/Time Format.
4. For the letters and patterns that you can use in a date format, see "Defining a date/time
format" below.
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.
Page 283