Date Format - Fields

 

Date Format

Expand/Collapse all Show/Hide All

Format Type

Select the format type.

  • Select Short to use a MM/DD/YY format.

  • Select Long to use the day, descriptive month, date, and 4-digit year.

  • Select Custom to allow each component of the date mask to be specified. If any settings are changed, the type is changed to Custom automatically.

 

Order

Select an order option.

  • Select MDY to use an order of month, date, year.

  • Select DMY to use an order of date, month, year.

  • Select YMD to use an order of year, month, date.

 

Day Display

Select the day-of-the-week format to use. You can also type a separator character to follow the day description.

  • Select Long to use the full name for the day of the week.

  • Select Short to use the abbreviation for the day of the week.

  • Select None if you do not want to include the day of the week.

Expand or collapse item Example

Selection

Example

Long

Friday

Short

Fri

 

 

Month

Select the month format.

Expand or collapse item Entry Sample

Select....

To....

1

display a one-digit month format

01

display a two-digit month format.

Jan

display a three-character description.

January

display the entire name of the month.

None

not display the month at all.

  • Select 1 to use a one-digit

 

Day

Select the day format.

Expand or collapse item Entry Sample

Select....

To....

1

display a one-digit day format.

01

display a two-digit day format.

None

not display the day at all.

 

Year

Select the year format.

Expand or collapse item Entry Sample

Select....

To....

98

display a two-digit year format.

1998

display a four-digit year format.

None

not display the year at all.

 

Separators

Type the separator character for the first and second segment of the date.