In Tedds for Word, you can display the time and date in virtually any format that you require. The valid time and date formatting options are shown in the table below. For simplicity, the results are shown for 09:05:07 on Thursday 5 June 2013.
Date formatting options
Period of time
Code
Result
Comment
Day
d or D
5
Not applicable
dd or DD
05
Not applicable
ddd or DDD
Thu
Note:
To display the day and the date, you can use 2 format strings.
For example, "Thu 5" would be spelled "ddd d", and "Thursday 5" would be spelled "dddd d".
dddd or DDDD
Thursday
Month
M
6
Note:
Use capital M to differentiate months from minutes (m).
MM
06
MMM
Jun
MMMM
June
Year
yy or YY
13
Note:
y, Y, yyy and YYY are not valid formats.
yyyy or YYYY
2013
Time formatting options
Period of time
Code
Result
Comment
Hour
h
9
Based on 12-hour clock
H
9
Based on 24-hour clock
hh
09
Based on 12-hour clock
HH
09
Based on 24-hour clock
Minute
m
5
Note:
Use a lower case m to differentiate minutes from months (M).
mm
05
Second
s or S
7
Not applicable
ss or SS
07
'text'
Specify text in single quotation marks to include it in the appropriate format.
For example, Time("hh' Greenwich mean time' ") displays "09 Greenwich mean time".
character
Includes the specified character in the date or time.
For example, Time("HH:mm MMM-d, yyyy") displays "11:15 Nov-6, 2013".
