C. Data Format Templates : Date Format Templates : Absolute Date and Time Format Templates : Guidelines for Using Absolute Date Templates
 
Share this page                  
Guidelines for Using Absolute Date Templates
Observe the following guidelines when using absolute date templates:
• On a date template you can enter only the month's name of February, the weekday of Sunday, and the time designation p or p.m.
• You can specify 24-hour time by using 16 instead of 4 for 4 p.m.
You cannot use p or p.m. with 24-hour time.
• Display the numeric day of the year by specifying the day and year, but leaving out the month.
For example, 3/1901 in the template results in dates like 121/1988 for April 30, 1988.
• You can create ordinal numbers from numerals by appending the appropriate suffix (st, nd, rd, or th).
For example, the template 3rd day of February 1901 produces a date like 15th day of January, 1988.
• Numbers requiring more than one digit use up preceding blanks or zeros.
If there are no preceding blanks or zeros remaining, the number expands to the right. A blank following a letter, word, or number is not used up by a succeeding number. Columns of numbers can be lined up by preceding them with an appropriate number of blanks or zeros.
Examples of Absolute Date Templates
The following table provides examples of absolute date and time templates:
Format
Example Data
Output
2/3/1
25-oct-1982
10/25/82
2/3/1
5-jun-1909
6/5/9
2/ 3/01
25-oct-1982
10/25/82
2/ 3/01
5-jun-1909
6/ 5/09
03-02-01
5-oct-1982 07:24:12
05-10-82
010203
5-oct-1982
821005
1\|2\|3
5-oct-1982
82|10|5
FEBRUARY, 1901
1-sep-2134 09:13:02
SEPTEMBER, 2134
FEBRUARY, 1901
2-apr-1962 17:46:03
APRIL, 1962
Sunday
5-oct-1983
Wednesday
SUN Feb 3 16:05 1901
13-oct-1983 07:24:03
THU Oct 13 07:24 1983
FEB 03 4:05:06 p.m.
12-dec-1983 22:13:03
DEC 12 10:13:03 p.m.
04:05:06 PM
5-oct-1983 14:08:45
02:08:45 PM
04:05:06 PM
5-oct-1983 07:29:12
07:29:12 AM
16:05 pst
5-oct-1983 14:08:45
14:08 pst
3/01
5-oct-1983
278/83
February 3rd
29-jul-1954
July 29th
3rd day of 1901
11-may-1999
131st day of 1999