2018.2

l
Extraction:
l
In the Data Model, select a field.
l
On the Step properties pane, under Field Definition set the Type to Currency.
l
Under Data Format, specify how the value is formatted in the data source (see
Extract Step; for the default format settings, see "Data source settings" on
page177).
The field value will be extracted and treated as a Float.
l
JavaScript Expression: Set the desired value to any Float value. Example:
record.fields["PreciseTaxSubtotal"] = 27.13465;
Note
While Currency values can be set to up to 4 significant digits, only 2 are displayed on screen.
Building Currency values
Currency values can be the result of direct attribution or mathematical operations just like
Integer values (see "Integer" on page237).
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 using the system's regional
settings, in reality they are stored unformatted.
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 in the database (with 0 time zone offset). This
is expected behavior for the moment and the zone offset must be calculated manually in
PlanetPress Workflow.
Page 233