1.6

Table Of Contents
Note
The Date property is stored in Connect database with zero time zone offset, which makes it
possible to convert the time correctly in any location. PlanetPress Workflow, however, shows the
date/time as it is stored database (with 0 time zone offset). This is expected behavior for the moment
and the zone offset must be calculated manually in PlanetPress Workflow.
Extracting dates
To extract data and have that data interpreted as a Date, set the type of the respective field to
Date:
1. Select the field in the data model.
2.
On the Step properties pane, under Field Definition, specify the Type as Date.
3.
Next, under Data Format, specify the Date/Time Format. This format must match the way
the date is formatted in the source data; otherwise the data cannot be interpreted as a
Date.
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.
Page 145