Date/Time Variables

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

More information:

Microsoft date time strings