The following date/time field variables are used:
d |
08/17/2000 |
D |
Thursday, August 17, 2000 |
f |
Thursday, August 17, 2000 16:32 |
F |
Thursday, August 17, 2000 16:32:32 |
g |
08/17/2000 16:32 |
G |
08/17/2000 16:32:32 |
m |
August 17 |
r |
Thu, 17 Aug 2000 23:32:32 GMT |
s |
2000-08-17T16:32:32 |
|
|
t |
16:32 |
T |
16:32:32 |
u |
2000-08-17 23:32:32Z |
U |
Thursday, August 17, 2000 23:32:32 |
y |
August, 2000 |
|
|
d, dd, ddd, dddd |
Current day of the month d, dd=numeric, ddd=abbreviation (ie, "Wed"), dddd=spelled out. |
f, ff, fff, ffff, fffff |
Fractions of a second, varying numbers of digits |
h, hh Hours |
12 hour format |
H, HH Hours |
24 hour format |
m, mm: |
Minutes |
M, MM, MMM, MMMM |
Month. MM = 2 digit, MMM = abbreviation (ie, "Jan"), MMMM=spelled out |
s, ss |
Seconds |
t, tt |
AM/PM indicator |
y, yy, yyyy |
Year |
z, zz, zzz |
Time zone offset from GMT. Time separator |
/ |
Date separator |
Any other character |
Other characters |
|
|
Examples: |
|
dddd, MMMM dd yyyy |
Thursday, August 17 2000 |
ddd, MMM d "'"yy |
Thu, Aug 17 '00 |
dddd, MMMM dd |
Thursday, August 17 |
M/yy |
8/00 |
dd-MM-yy |
17-08-00 |
Other time span options:
totalmilliseconds
totalseconds
totalminutes
totalhours
totaldays
To get single date parts you can use percentage sign first:
{DATEFORMAT(%M)}
{DATEFORMAT(%d)}
More information:
If you have a problem with Variables displaying other format than system it might be because you need to check the following below: