This field allows you to specify the format for " Date " properties. When the user is prompted to select a day from a calendar, you can specify that the first day of the week begins with " Monday," that the " first week of the year" is the " First full week," and that the date value will follow the format defined by " Date Format."


 


You can define a custom date format:


Characters

Description

d

Displays the day as a number without a leading zero (example 1). Use %d if this is the only character in the user-defined numeric format

dd

Displays the day as a number with a leading zero (e.g., 01)

ddd

Displays the day as an abbreviation (e.g., Mon.)

dddd

Displays the day as an abbreviation (e.g., Monday)

M

Displays the month as a number without a leading zero (for example, January is represented as 1). Use %M if it is the only character in the user-defined numeric format.

MM

Displays the month as a number with a leading zero (for example, January is displayed as 01)

MMM

Displays the month as an abbreviation (for example, January is displayed as Jan.)

MMMM

Displays the month as a full month name (e.g., January)

y

Displays the year in a numeric format without leading zeros (e.g., 0–9). Use %Y if this is the only character in the user-defined numeric format.

yy

Displays the year in a two-digit numeric format with a leading zero if necessary (for example, January is displayed as 01)

yyy

Not available

yyyy

Displays the year in a four-digit numeric format


Please use the correct case (upper/lowercase) and specify the separators of your choice.

Here are a few examples of user-defined date formats for Thursday, October 18, 2012.


Format

Poster

dd-MM-yy

10/18/12

dd/MM/yy

10/18/12

M/d/yy

10/18/12

d MMM yy

Oct. 18, 2012

d MMMM yyyy

October 18, 2012