Date Time Field Options

A date time field allows a workflow to capture dates and times from the console.

Option Description
Time interval from Now Choose this option to specify that the default value of the field will be the time when the user opens a form plus the interval. In the box, specify the interval in the following format:

[-]d[. hh[: mm[:[ss .[ff]]]]]

In this syntax, d is days, hh is hours, mm is minutes, ss is seconds, and ff can be used to specify hundredths of a second. To specify an interval in the past, precede the interval with the minus symbol (-) .

Examples:

To specify one day earlier, type:

-1

To specify 30 minutes later, type:

0.00.30
Fixed Time Choose this option to specify that the value of a field when a user opens up a form will be exactly as specified in the Fixed Time box. Click the button to select a date in the calendar control.
Displayed format on the device side This option defines the format of the date or time as a date/time value will appear on the device panel. Create the format string using the date and time format variables listed for Custom Date and Time Format Strings .

Custom Date and Time Format Strings

The date/time format string specifies how a date and/or time should be formatted when displayed. Some of these formats are not available on all devices.

Table 1. Date format variables
Format variable Description
d Displays the day of the month (1 – 31). If the day can be expressed as a single digit number, then it will be formatted with one digit.
dd Displays the day of the month (01 – 31) as a two-digit number. Single digit days will have a leading zero added.
o Displays the day of the year (1 – 365). If the day can be expressed as a single digit number, then it will be formatted with one digit. The same holds for two-digit and three-digit numbers.
oo Displays the day of the year (001 –  365) as a three-digit number. Single-digit and two-digit days will have a leading zeros added.
D Displays the abbreviated name of the day. For example, "Monday" is displayed as "Mon".
DD Displays the full name of the day. For example, "Monday" is displayed as "Monday".
m Displays the month of the year (1 – 12). If the month can be expressed as a single digit number, then it will be formatted with one digit.
mm Displays the month of the year (01 – 12). Single-digit months will have a leading zero added.
M Displays the abbreviated name of the month (for example “Jan,” “Feb”).
MM Displays the full name of the month (for example “January,” “February”).
y Displays the last two digits of the year.
yy Displays all four digits of the year.
@ Displays the UNIX timestamp (the number of milliseconds (ms) since 01/01/1970).
! Displays the number of Windows ticks (the number of 100 nanoseconds (ns) since 01/01/0001).
'...' Displays the text within the quotes. Note that if anything other than a format variable is used, it will be displayed as text as well.
" Displays a single set of quotes.
Table 2. Time format variables
Format variable Description
h Displays the hour with no leading zero.
hh Displays the hour with a leading zero.
m Displays the minute with no leading zero.
mm Displays the minute with a leading zero.
s Displays the second with no leading zero.
ss Displays the second with a leading zero.
l Displays milliseconds. This is always displayed with leading zeros.
t Displays a for AM or p for PM.
T Displays A for AM or P for PM.
tt Displays am or pm.
TT Displays AM or PM.

Examples:

  • DD, MM dd, yy is “Monday, January 03, 2009”
  • yy-mm-dd hh:mm is “2009-01-03 05:35”
  • h:mm TT is “3:35 PM”