U of A logo - Return to U of A Home Page Return to BASIS Home Page - WOO PIG! Sooiiee! Razorbacks!!


Alternate Entry Formats

Date Formats

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





Cost Center Formats

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.