2021.2

Building Currency values
Currency values can be the result of direct attribution or mathematical operations just like
Integer values (see "Integer" on page293).
Date
Dates are values that represent a specific point in time, precise up to the second. They can also
be referred to as datetime values. While dates are displayed as UTC (Coordinated Universal
Time) or using the system's regional settings (see "Default Format" on page852), in reality they
are stored unformatted.
Note
The Date property is stored in the 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 in the database (with 0 time zone offset). This
is expected behavior 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. Make sure that the date in the data source is formatted in a way that matches the
expectations of the DataMapper. If the date doesn't match the format that the DataMapper
expects, it cannot be interpreted as a date. For example, if a date in the data source is
formatted as "yyyy-mm-dd" but the DataMapper expects a time as well, the date cannot be
read and the DataMapper will stop with an error.
The expected date format can be set in three places:
l In the user preferences ("DataMapper preferences" on page852).
l In the data source settings ("Data source settings" on page224).
l In the field properties: on the Step properties pane, under Data Format, specify the
Date/Time Format.
Page 289