1.4

The available formatting functions depend on the data type of the corresponding field in the
Data Model. In a Data Mapping Configuration you can set the data type of each field. When you
open a data file or database without a Data Mapping Configuration, all fields are text fields
(fields of the type string).
You could also format data in a script using the formatter ; see "API" on page 174.
Date
Dates in variable data can be displayed as long, medium and short dates with different time
displays. There are quite a few presets, but you can also enter a custom format mask.
1. Open the Text Script Wizard: double-click to open an existing script in the Scripts pane or
create a new Text Script using the Text Script Wizard; see "Using the Text Script Wizard"
on page 338.
2. Click a data field that contains text, or add such a data field to the script with the Add field
button on the right.
3.
Under Format you can choose one of the following options:
l
Short Date displays the day, month and year in two digits each, for example
01.04.16.
l
Medium Date displays the day and month in two digits each and the year in four
digits, for example 01.04.2016. (This is also the value of the Default Date.)
l
Long Date displays the day as a number, the month's full name and the year in four
digits, for example 1. April 2016.
l
Short Time displays a time in hours and minutes in two digits each, for example
00:00.
l
Medium Time displays a time in hours, minutes and seconds in two digits each, for
example 00:00:00. (This is also the value of the Default Time.)
l
Long Time displays a time in hours, minutes and seconds in two digits each, and
adds a time zone, for example 00:00:00 EDT.
l
Short Date/Time displays the date as a short date and the time as a short time, for
example 01.04.16 00:00.
l
Medium Date/Time displays the date as a medium date and the time as a medium
time, for example 01.04.2016 00:00:00 (This is also the value of the Default
Date/Time.)
l
Long Date/Time displays the date as a medium date and the time as a medium
time, for example 1. April 2016 00:00:00 EDT.
Page 342