Field | Description |
Type
|
Click
in this field, and select the date type from the list.
The options (with examples in parenthesis) are:
-
Short date (8/21/2015)
-
Medium date (August 21, 2015)
-
Long date (Thursday, August 21, 2015)
-
Short date and time (8/21/2015 04:11:44)
-
Time (04:11:44)
After you select a date type, to further modify it, select or clear the check boxes in the
Date options section in this dialog box. For example, clear the
Display day check box to remove the display of the day from the date.
|
Sample
|
This field displays an example of how the date and time display based on your selection in the
Type field and the options that you choose in the
Date options and
Time options sections.
|
Date Options Section
After you select the date type, use this section to define how the date displays. This section is fully enabled when you select
Short date, Medium date,
Long date, or
Short date and time in the
Type field on this dialog box. When you select
Time in the
Type field, only the
Display four digit year
and
Display leading zeros check boxes are enabled in this section.
Field | Description |
Use separator from regional settings
|
Select this check box to use the separator that is entered for the regional settings in Microsoft Windows as the separator between the day, month, and year in the date.
|
Date Separator
|
From the drop-down list, select the character to use as a separator between the day, month, and year in the date. This field is enabled only if you do not select the
Use separator from regional settings check box.
|
Date order
|
From the drop-down list, select the order of the month, day, and year in the date. When you make a selection in this field, the date that is displayed in the
Sample field changes accordingly.
|
Display day
|
Select this check box if you want the day included in the date. Clear the check box if you want to omit the day from the date.
|
Display month
|
Select this check box if you want the month included in the date. Clear the check box if you want to omit the month from the date.
|
Display year
|
Select this check box if you want the year included in the date. Clear the check box if you want to omit the year from the date.
|
Display four digit year
|
Select this check box if you want the year displayed with four digits. Clear this check box if you want the year displayed with two digits.
|
Display leading zeros
|
Select this check box if you want leading zeros displayed in dates. For example, the month of August displays as 08 instead of 8.
Clear this check box if you do not want leading zeros displayed in dates.
|
Time Options Section
Use this section to determine how the time (hours, minutes, and seconds) is formatted. This section is enabled only when you select
Short date and time or
Time in the
Type field.
Field | Description |
Use separator from regional settings
|
Select this check box to use the separator that is entered for the regional settings in Microsoft Windows as the separator between the day, moth, and year in the time.
|
Time Separator
|
From the drop-down list, select the character to use as a separator between the time components (hour, minutes, and seconds).
|
24-hour clock
|
Select this check box if you want the displayed time to be based on 24 hours, numbered from 0 to 23.
|
Display AM/PM
|
Select this check box if you want the labels AM and PM included with the time.
|