Input time formats

T<timeformat>

timeformat is a text string expression of the date/time value. The syntax can be one or combination of the following elements

yyyy	year (100-9999)
yy	year (00-99, for 00-79, it means 2000-2079, for 80-99, it means 1980-1999)
MM	month (00-12)
dd	day of month (00-31, validate date when year and month are available)
DDD	day of year (000-366, validate date when year and month are available)
HH	hour (00-23)
hh	hour (01-12)
mm	minute (00-59)
ss	second (00-59)
TT	AM/PM
T	A/P
tt	am/pm
t	a/p
"text"	text is a fixed text string.

The following date/time elements cannot be repeated in the timeformat. For example, if you have selected yyyy for year date format, you cannot use yy or another yyyy in the timeformat. This limitation includes:

yyyy and yy

dd and DDD

HH and hh

HH, TT, T, tt and t

Examples

T<yyyyMMdd>

Description — a full date.

Valid input examples

20051025

19000101

Invalid input examples

2005/10/25	unexpected character /
20051032	invalid date
00990101	date is earlier than 1000
20050229	invalid date (because the year 2005 was not a leap year)

T<MMdd>

Description — a date without a year specified.

Valid input examples

1201

1231

0229

Invalid input examples

0001	invalid month
0230	invalid date of February regardless if it is a leap year
ABCDEF	date is earlier than 1000

T<HH":"mm":"ss>

Description — a time with : as separator.

Valid input examples

23:59:59

00:00:00

Invalid input examples

99:59:00	invalid hour
120000	no separator

T<hhmmsst>

Description — a full time.

Valid input examples

010000a

120000p

Invalid input examples

010000A	A should be lower case
000000a	invalid time
1355101	invalid hour must be 00-12

T<HHmmssTT>

Description — this is an invalid input format because HH represents 00 to 23 hours and TT represents AM/PM which is not valid with 24 hour time string.

T<yyyyMMyyyy>

Description — this is an invalid input format for yyyy because it was used more than once in a timeformat.