When using a variable for process fields that contains date values, the formatting can be specified. The form of display and the time zone calculation can be influenced. You can always decide whether you want to use e.g. a date with or without time indication, and whether the time should be converted according to the user's time zone or should be recalculated into a set time zone.
Please note: For .NET system activities (e.g. JobFerd, JobPDF, JobDocuWare, JobPGP, ShellExecute, JobMind) the formattings mentioned below do not take effect.
For example: Use the following syntax for an Indate date field:
(indate:<formatting>|<time zone>)
Formatting and time zone settings are optional.
If you only want a specific formatting without calculating a different time zone, you can use the following syntax:
(indate:<formatting>)
If you only want a specific time zone without a specific formatting, you can use the following syntax:
(indate:<time zone>)
Possible <formatting> values are:
•userdate = date in user date format
•userdatetime = date and time in user date format
•systemdate = date in JobRouter default date format
•systemdatetime = date and time in JobRouter default date format
•a format pattern accepted by the date() PHP function (for further information see http://www.php.net/manual/en/function.date.php)
Possible <time zone> values are:
•usertimezone = user time zone
•systemtimezone = JobRouter time zone
•a time zone returned by the timezone_identifiers_list() PHP function (for further information see http://www.php.net/manual/en/function.timezone-identifiers-list.php)
Following are some concrete examples for formatting and converting date variables. The following parameters are used as a basis:
•User date format: d.m.Y
•User time zone: Europe/Berlin
•JobRouter date format: m/d/Y
•JobRouter time zone = UTC
•Date value in the Process table field Indate (as JobRouter time zone): 01.12.2013 00:00:00
(indate:userdatetime|usertimezone) → 01.12.2013 01:00:00
(indate:userdatetime|Pacific/Chatham) → 01.12.2013 12:45:00
(indate:Y-m-d|systemtimezone) → 2013-12-01
For subtables the row id should be taken into account. The following additional parameters are used as a basis:
•Subtable: mySubtable
•Row id: 1 (i.e. first row)
See the examples below:
(mySubtable->indate:1:userdatetime|usertimezone) → 01.12.2013 01:00:00
(mySubTable->indate:1:userdatetime|Pacific/Chatham) → 01.12.2013 12:45:00
(mySubTable->indate:1:Y-m-d|systemtimezone) → 2013-12-01
