Show/Hide Toolbars

 

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:

Microsoft date time strings

 

 

If you have a problem with Variables displaying other format than system it might be because you need to check the following below:

 

clip0fdgdfggdf069