4-26 A-61635 December 2010
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:
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
20050229 invalid date (because the year 2005 was not a leap year)
00990101 date is earlier than 1000
yyyy year (1000-9999)
yy year (00-99, for 00-79, it means 2000-2079, for 80-99, it means
1980-1999)
MM month (01-12)
dd day of month (00-31, validate date when year and month are available)
DDD day of year (001-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.
To Next Page
Loading...