MsoDateTimeFormat Enumeration (Office)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the format of a date/time data type.

Name

Value

Description

msoDateTimeddddMMMMddyyyy

2

Specifies a ddddMMMMddyyyy format.

msoDateTimedMMMMyyyy

3

Specifies MMMMyyyy format.

msoDateTimedMMMyy

5

Specifies MMMyy format.

msoDateTimeFigureOut

14

Specifies that the Office application will determine the format.

msoDateTimeFormatMixed

-2

Specifies a mixed format.

msoDateTimeHmm

10

Specifies Hmm format.

msoDateTimehmmAMPM

12

Specifies a hmmAMPM format.

msoDateTimeHmmss

11

Specifies a Hmmss format.

msoDateTimehmmssAMPM

13

Specifies a hmmssAMPM format.

msoDateTimeMdyy

1

Specifies a Mdyy format.

msoDateTimeMMddyyHmm

8

Specifies a MMddyyHmm format.

msoDateTimeMMddyyhmmAMPM

9

Specifies a MMddyyhmmAMPM format.

msoDateTimeMMMMdyyyy

4

Specifies a MMMMdyyyy format.

msoDateTimeMMMMyy

6

Specifies a MMMMyy format.

msoDateTimeMMyy

7

Specifies a MMyy format.

Show: