Both Cell and Group format preferences can be set for time/date values (for columns that display time and date). The format options available for a column that displays Time/Date are the same for both cells and groups and are available within the 'Date' tab in the format dialogs.
The dialog above shows an example of a 'Cell Format' dialog for a Time/Date-type column.
The default settings are determined by your 'Regional' options within Windows.
|
TIP |
A live approximation of the current time/date format will be shown in the 'Sample' section. |
|---|
Date Options
The following Date options are available:
'All' = Weekday, month, day, and year
'Only day'
'Only month'
'Only month and day'
'Only month and year'
'Only month, day, and year'
'Only weekday'
'Only weekday, month, and day'
'Only year'
The checkboxes below toggle options as follows:
'Show today when appropriate'
'Always show 4-digit year'
'Show 4-digit year for 21st century'
'Show year only if not this year'
-
'Calendar': This dropdown menu lets you choose between Gregorian or Hijri calendars.
-
'Format': This dropdown menu lets you set the order of the Weekday, Month, Day, and Year readout.
-
'Separators': These fields allow you to set independent separator characters to separate date elements.
-
Day-Month-Year-Weekday: These dropdown menus let you set the number of digits to display for date elements.
|
TIP |
Unchecking both 'Display Date' and 'Display Time' checkboxes will trigger a default, MM/DD/YYYY date readout. |
|---|
Time Options
The following Time options are available:
General Dialog Options
|
NOTE |
Note about Group/Cell format:
|
|---|
