Specifies the format of a date/time data type. format.

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
msoDateTimeMMMMdyyyy 4 Specifies a MMMMdyyyy format.
msoDateTimeMMMMyy 6 Specifies a MMMMyy format.
msoDateTimeMMyy 7 Specifies a MMyy format.