Date Format
Show/Hide All
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.
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.
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.
Selection
Example
Long
Friday
Short
Fri
Select the month format.
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
Select the day format.
Select....
To....
1
display a one-digit day format.
01
display a two-digit day format.
None
not display the day at all.
Select the year format.
Select....
To....
98
display a two-digit year format.
1998
display a four-digit year format.
None
not display the year at all.
Type the separator character for the first and second segment of the date.
© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks