Toggle Help Topics Menu >

Date Formats

Date Codes

 

Date Part

Date Code

Display

Day

d

1-31

dd

01-31

ddd

Sun-Sat

dddd

Sunday-Saturday

Month

m

1-12

mm

01-12

mmm

Jan-Dec

mmmm

January-December

mmmmm

J-D (1st letter of month)

Year

yy

00-99

yyyy

1900-9999

Locale

[$-800] or *

(placed before date)

Use localized day and month names

 

Time Codes

Time Part

Time Code

Display

Hour

h

Hours as 0-23

hh

Hours as 00-23

Minute

m

Minutes as 0-59

mm

Minutes as 00-59

Second

s

Seconds as 0-59

ss

Seconds as 00-59

ss.00

Fractions of a second

AM/PM

AM/PM

12-hour clock (e.g,, 2 PM)

A/P

12-hour clock (e.g,, 2 P)

{none}

If AM/PM omitted, will display 24-hour clock

Span

[h]:mm

Elapsed time in hours

[mm]:ss

Elapsed time in minutes

[ss]

Elapsed time in seconds