Date Time field

Option Description
Custom Format Allows the administrator to create a unique schema.
Default The value shown here will automatically populate the field until or unless changed by a user.
Mode
  • Date — Entry for date only
  • Time — Entry for time only
  • Date and Time — Entry for date and time
Show in Smarticket Choosing Yes means that the field value name will appear on the Smarticket barcode sheet when printed.

Defined Date Time formats

Name Format Specifier Example
Short Date d 1/1/2011 12:35:45 AM -> 1/1/2011
Long Date D 1/1/2011 12:35:45 AM -> Saturday, January 1, 2011
Short Time t 1/1/2011 12:35:45 AM -> Saturday, January 1, 2011 12:34 AM
Long Time T 1/1/2011 12:35:45 AM -> Saturday, January 1, 2011 12:34:45
Short Date and Time g 1/1/2011 12:35:45 AM -> 1/1/2011 12:34 AM
Long Date and Time F 1/1/2011 12:35:45 AM -> 1/1/2011 12:34:45 AM

Custom Date Time formats

Use the time separator “:” and the date separator “/” in custom date time format strings.

Description Format Specifier Examples
The day of the month, from 1 through 31 d 1/1/2011 12:35:45 AM -> 1
The day of the month, from 1 through 31 dd 1/1/2011 12:35:45 AM -> 01
The abbreviated name of the day of the week. ddd 1/1/2011 12:35:45 AM -> Sat
The full name of the day of the week dddd 1/1/2011 12:35:45 AM -> Saturday
The tenths of a second in a date and time value f 1/1/2011 12:35:45:7348592 AM -> 7

1/1/2011 12:35:45:01 -> 0

The hundredths of a second in a date and time value ff 1/1/2011 12:35:45:7348592 AM -> 73

1/1/2011 12:35:45:003 -> 00

The milliseconds of a second in a date and time value fff 1/1/2011 12:35:45:7348592 AM -> 734

1/1/2011 12:35:45:0005 -> 000

The ten thousandth of a second in a date and time value ffff 1/1/2011 12:35:45:7348592 AM -> 7348

1/1/2011 12:35:45:00001 -> 0000

The hundred thousandths of a second in a date and time value fffff 1/1/2011 12:35:45:7348592 AM -> 73485

1/1/2011 12:35:45:000004 -> 00000

The millionths of a second in a date and time value ffffff 1/1/2011 12:35:45:7348592 AM -> 734859

1/1/2011 12:35:45:0000006 -> 000000

The ten millionths of a second in a date and time value fffffff 1/1/2011 12:35:45:7348592 AM -> 7348592

1/1/2011 12:35:45:00000008 – 0000000

If non-zero, the tenths of a second in a date and time value F 1/1/2011 12:35:45:7348592 AM -> 7

No output for 1/1/2011 12:35:45:010

If non-zero, the hundredths of a second in a date and time value FF 1/1/2011 12:35:45:7348592 AM -> 73

No output for 1/1/2011 12:35:45:005

If non-zero, the milliseconds in a date and time value FFF 1/1/2011 12:35:45:7348592 AM -> 734

No output for 1/1/2011 12:35:45:0005

If non-zero, the ten thousandths of a second in a date and time value FFFF 1/1/2011 12:35:45:7348592 AM -> 7348

No output for 1/1/2011 12:35:45:00005

If non-zero, the hundred thousandths of a second in a date and time value FFFFF 1/1/2011 12:35:45:7348592 AM -> 73485

No output for 1/1/2011 12:35:45:000005

If non-zero, the millionths of a second in a date and time value FFFFFF 1/1/2011 12:35:45:7348592 AM -> 734859

No output for 1/1/2011 12:35:45:0000005

If non-zero, the ten millionths of a second in a date and time value FFFFFFF 1/1/2011 12:35:45:7348592 AM -> 7348592

No output for 1/1/2011 12:35:45:00000005

The period or era g or gg 1/1/2011 12:35:45 AM -> A.D.
The hour, using a 12-hour clock from 1 to 12 h 1/1/2011 12:35:45 AM -> 12
The hour, using a 12-hour clock from 01 to 12 hh 1/1/2011 12:35:45 AM -> 12

1/1/2011 4:35:45 AM -> 04

The hour, using a 24-hour clock from 0 to 23 H 1/1/2011 12:35:45 AM -> 0
The hour, using a 24-hour clock from 00 to 23 HH 1/1/2011 12:35:45 AM -> 00

1/1/2011 3:35:45 PM -> 15

Time zone information K 1/1/2011 12:35:45 AM Kind Unspecified -> no output
The minute, from 0 through 59 m 1/1/2011 12:35:45 AM -> 35
The minute, from 00 through 59 mm 1/1/2011 12:35:45 AM -> 35
The month, from 1 through 12 M 1/1/2011 12:35:45 AM -> 1
The month, from 01 through 12 MM 1/1/2011 12:35:45 AM -> 01
The abbreviated name of the month MMM 1/1/2011 12:35:45 AM -> Jan
The full name of the month MMMM 1/1/2011 12:35:45 AM -> January
The second, from 0 through 59 s 1/1/2011 12:35:45 AM -> 45
The second from 00 through 59 ss 1/1/2011 12:35:45 AM -> 45
The first character of the AM/PM designator t 1/1/2011 12:35:45 AM -> A
The AM/PM designator tt 1/1/2011 12:35:45 AM -> AM
The year from 0 to 99 y 1/1/2011 12:35:45 AM -> 1
The year from 00 to 99 yy 1/1/2011 12:35:45 AM -> 11
The year, with a minimum of three digits yyy 1/1/2011 12:35:45 AM -> 2011

1/1/0001 12:35:45 AM -> 001

The year as a four digit number yyyy 1/1/2011 12:35:45 AM -> 2011
The year as a five digit number yyyyy 1/1/2011 12:35:45 AM -> 02011
Hours offset from UTC, with no leading zeroes z 1/1/2011 12:35:45 AM -07:00 -> -7
Hours offset from UTC, with a leading zero for a single digit value zz 1/1/2011 12:35:45 AM -07:00 -> -07
Hours and minutes offset from UTC zzz 1/1/2011 12:35:45 AM -07:00 -> 07:00