Departmental databases Step 2C - Evaluate Potential Data Problems
Determine whether date conversion is necessary. (Specific suggestions for handling year 2000 dates are given in Step 5.)
Spreadsheets and reports, etc.
It may not be necessary or urgent to fix all date occurrences if the dates are only used for displaying or printing. If, however, dates (including the year) are used in calculations, sorts, or other processing, you may have to expand the dates. For spreadsheets, this also means changing the format. Again, whether or not a fix is required will depend on how critical the process is to your department's business functions.
Data used in your department but not created by your department
If data is received or derived from an ITS-maintained central application, some other College department, or from an outside vendor or agency, determine the provider's year 2000 solution and modify local processes to accommodate changes, as appropriate.
Shared data and other cross-system interfaces
Shared data presents one of the greatest risks of year 2000 failure. If you prepare data for input to ITS-maintained central systems, to other College departmental systems, or to outside agencies or partners, you must coordinate with the receiving area to determine the appropriate year 2000 solution.
Year 2000 Databases and Shared Data Inventory Worksheet
Back to Tool Kit Steps Go to next step
|
Return Home |