Date and time format of property text

You can use the following as delimiters in your date/time:

/ : - _ , . < > ? ; ' { [ ] = ( ) * & ^ % # @ ! ~ ` \ "

You cannot use the right brace or the vertical bar:

} |

d

The day is displayed as a number with no leading zero for single-digit days.

dd

The day is displayed as a number with a leading zero for single-digit days.

dd→date (1–31)

/DT

Displays date and time in the following format: yyyy/MMMM:dddd-hh_mm,ss.tt

ddd

The day is displayed as a three-letter abbreviation, specified by the LOCALE_SABBREVDAYNAME registry value.

ddd→Mon

dddd

The day is displayed as specified by the LOCALE_SDAYNAME registry value.

dddd→Monday

M

The month is displayed as a number with no leading zero for single-digit months.

MM

The month is displayed as a number with a leading zero for single-digit months.

MM→03

MMM

The month is displayed as a three-letter abbreviation, specified by the LOCALE_SABBREVMONTHNAME registry value.

MMMM

The month is displayed as specified by the LOCALE_SMONTHNAME registry value.

MMMM→March

y

The year is displayed as the last digit.

yy

The year is displayed as the last two digits.

yy→10

yyyy

The year is displayed as four digits.

YYYY→2010

h

The hour is displayed with no leading zero for single-digit hours (12-hour time format).

hh

The hour is displayed with a leading zero for single-digit hours (12-hour time format).

H

The hour is displayed with no leading zero for single-digit hours (24-hour time format).

HH

The hour is displayed with a leading zero for single-digit hours (24-hour time format).

m

The minute is displayed with no leading zero for single-digit minutes.

mm

The minute is displayed with a leading zero for single-digit minutes.

s

The second is displayed with no leading zero for single-digit seconds.

ss

The second is displayed with a leading zero for single-digit seconds.

t

AM/PM is represented as one character (A or P).

tt

AM/PM is represented as two characters.

What are you looking for?
How do I
Learn more about
Look up more details