Reference : Attribute types : Text : Text tags for date and time
  
Text tags for date and time
In text attributes, you can use tags to indicate date and time values.
 
Symbol
Meaning
Example
G
Era
AD
y
Year
07
M
Month
Jul (July)
d
Day in month
10
h
Hour in a.m. and p.m. (1 - 12)
12
H
Hour in day (0 - 23)
0
m
Minute
30
s
Second
55
S
Millisecond
978
E
Day in week
Tue (Tuesday)
D
Day in year
189
F
Day of week in month
2 (the second Friday in July)
w
Week in year
27
W
Week in month
2
a
a.m. and p.m. marker
PM
k
Hour in day (1 - 24)
24
K
Hour in a.m. and p.m. (0 - 11)
0
z
Time zone
Pacific Standard Time
'
Escape for text
 
''
Single quotation mark
'
'Text'
Text that you type in the field
Text
'INITIALS'
The initials of the user
JS
'USERNAME'
The user name of the user
johsm
'FULLNAME'
The full name of the user
John Smith
If the number of pattern letters is 4 or more, the full form is used; otherwise, a short or abbreviated form is used, if available. For example, EEEE might result in Tuesday, while E results in Tue. For more information, see the Java documentation about the SimpleDateFormat class.
John Smith is a user with the user name johsm. The date and time are 5 December 2007 at 11:55:26 in Central European Time. This table shows how the tags are used to enter this information.
 
Text tag
Result
INITIALS'yyyyMMdd':'
JS20071205:
'FULLNAME 'd' 'MMM' 'yyyy':'
John Smith 5 Dec 2007:
'INITIALS 'EEEEEEEEE' 'dd' 'MMMMMMMMM' 'yyyy' at 'hh':'mm' 'aa' ('z'):'
JS Wednesday 05 December 2007 at 11:55 AM (CET):
yyyy.MM.dd G 'at' HH:mm:ss z
2007.12.05 AD at 11:55:26 CET
'USERNAME Week 'w':'
johsm Week 48:
Related topics
Text formatting
Attribute types
Configuring attributes
Go up to
Text