A 10-character field is used to display all dates. To ease
data entry, the system accepts the entry of a date in
several formats and returns it in a standard format. The
proper convention is MM/DD/YYYY. A dash (-) or slash (/) is
acceptable as a divider between month, day, and year
components. You can also enter the date with no dividers.
In addition to the above format, the system will accept the
following:
-
MM-DD-YYYY
-
MM-DD-YY
-
MM/DD/YY
-
MMDDYY
-
MMDDYYYY
|
The following date ranges are available based on the format
used:
-
From 01/01/1911 through 12/31/2099 when two digit years
are entered. (i.e. 12/31/99)
-
From 01/01/1800 through 12/31/2099 when a fully formatted
8-digit date with delimiters are used. (i.e. entered as shown.)
|
When any date outside of the above ranges and formats is
entered, it is assumed that a date with only a two-digit
year has been typed in over an existing date and only the
first two digits are utilized. Whenever a two-digit
year is being utilized, if those digits are less than 11,
it is assumed to be in the 21st century, otherwise, it is
set to the 20th century. For example:
03/17/1799 |
is returned 03/17/1917 |
03/17/1800 |
is returned 03/17/1800 |
03171800 |
is returned 03/17/1918 |
03172100 |
is returned 03/17/1921 |
031711 |
is returned 03/17/1911 |
031710 |
is returned 03/17/2010 |
03/17/11 |
is returned 03/17/1911 |
03/17/10 |
is returned 03/17/2010 |
An 18 character field is most commonly used for company
cost center numbers. To ease data entry, the system accepts
the entry of a cost center number in several formats and
returns it in a standard format. The system also sets a 15
digit numeric value which is actually stored on the
database. The proper convention is 9999 99999-99-9999,
where the last four digits are an optional project number
that when not entered is returned as zeroes. In addition to
the above format, the system will accept the following:
- 999999999999999
- 9999-99999-99-9999
- 9999-99999-99
- 9999 99999-99
- 99999999999
|
Occasionally, a 15 character field is presented for entry
of a cost center number, and an 18 character formatted
field is returned. This version was developed to support
data-entry intensive functions, where the 15-digit number
could be entered and, because that filled the field, the
cursor would skip to the next required field without
tabbing forward.