DateTime format

 

Date area

Character

Meaning

Example

d

Day number with no leading zero

9

dd

Day number with leading zero if appropriate

09

ddd

Day name abbreviation

Mon

dddd

Day name

Monday

m

Month number with no leading zero

6

mm

Month number with leading zero if appropriate

06

mmm

Month name abbreviation

Jun

mmmm

Month name

June

yy

Two-digit year

97

yyyy

Four-digit year

1997

Examples

Format

Displays

[red]m/d/yy

1/30/98 (in red, if this is a format for input field)

d-mmm-yy

30-Jan-98

dd-mmmm

30-January

mmm-yy

Jan-98

dddd, mmm d, yyyy

Friday, Jan 30, 1998

Time Area

Character

Meaning

h

Hour with no leading zero (for example, 1)

hh

Hour with leading zero if appropriate (for example, 01)

m

Minute with no leading zero (must follow h or hh)

mm

Minute with leading zero if appropriate (must follow h or hh)

s

Second with no leading zero (must follow m or mm)

ss

Second with leading zero (must follow m or mm)

ffffff

Microseconds with no leading zeros. You can enter one to six f’s; each f represents a fraction of a second (must follow s or ss)

AM/PM

Two-character, uppercase abbreviation (AM or PM as appropriate)

am/pm

Two-character, lowercase abbreviation (am or pm as appropriate)

A/P

One-character, uppercase abbreviation (A or P as appropriate)

a/p

One-character, lowercase abbreviation (a or p as appropriate)

Examples

Format

Displays

h:mm AM/PM

9:45 PM

hh:mm A/P

09:45 P

h:mm:ss am/pm

9:45:33 pm

h:mm

21:45

h:mm:ss

21:45:33

h:mm:ss:f

21:45:33:2

h:mm:ss:fff

21:45:33:234

h:mm:ss:ffffff

21:45:33:234567

m/d/yy h:mm

1/30/98 21:45