Y2K Departmental Testing Departmental Strategies Testing Win NT Testing Win '95 Testing Win 3.1 Testing DOS Testing Macs FileMakerPro Databases Excel Spreadsheets Testing Non Standard Applications Testing Other devices Tested Standards Y2K FAQ's

Y2K Home Page DHMC Intranet User Support Departmental Year 2000 Strategies. User Support will test all "standard" applications and "standard" computer hardware. Departments are required to test all hardware and software that are "non standard" as well as databases and spreadsheets that might use date field incorrectly. Departmental devices with computer processors are also the responsibility of that department. Steps for Departmental Y2K Assessment Inventory all non-standard software, computers and devices that might rely on computer processors. Identify if those devices and applications are mission critical or clinical. Be sure to include the version number of all software. For devices that might rely on computer processors. If there are no batteries AND no way to set dates you can remove them from the inventory. Contact the manufacturers of all remaining inventory items for certification of Y2K compliance. Test non-standard computers. Test devices that allow for dates and time to be set. Test non standard applications. Review departmental databases and spreadsheets for two digit year fields that don't take advantage of the applications date number/field type. Any spread sheet or database that only has a two digit year field and does not use the application's date field/number type the application is not Y2K compliant. All mission critical Excel spreadsheets should be updated to Excel v'97 or v'98.

Roll over test:

Set the date and time to 12/31/99 @ 11:55 and watch the year roll over to the year 2000 without problems. Test the device functionality.

Start-up test:

Set the date and time to the last possible date that the device will be in use. Restart and test functionality.

Leap year test:

Set the date and time to 2/28/2000 @ 11:55 and watch the date roll over to 2/29. Test the device functionality.

These tests do not confirm that any application is Y2K compliant. However, they may identify the major problem areas.

Any spread sheet or database that only has a two digit year field and does not use the application's date field/number type is not Y2K compliant.

To test the applications field/number type feature &endash; perform the following tests. If applications do not have the "Auto Enter Today's Date" feature you will have to modify this process.

Roll over test:

• Set a field or cell to "Auto Enter Today's Date" if available.
• Set the computers date and time of the field or cell to 12/31/99 @ 11:55 pm
• Watch the year roll over to the year 2000
• Invoke the "Enter today's date feature" and see if the correct date is entered.
• Test the application's functionality.

Start-up test:

• Set the date and time of the cell to the last possible date that the application will be in use.
• Set a field or cell to "Auto Enter Today's Date" if available.
• Set the computer's date and time of the field or cell to the last possible date that the application will be in use.
• Invoke the "Enter today's date feature" and see if the correct date is entered.
• Test the application's functionality.

Leap year test:

• Set a field or cell to "Auto Enter Today's Date" if available.
• Set the computer's date and time to 2/28/2000 @ 11:55.
• Watch the year roll over to the year 2000
• Invoke the "Enter today's date feature" and see if the correct date is entered.
• Test the application's functionality.

II. Live test

• Select the "Date and Time" control panel and double click to open it.
• Type or click on the arrows to set the current date to 12/31/99, and current time to 11:59:00 PM
• Wait for more than one minute, and watch the display update
• The current date and current time in the display will change to 1/1/00, and 12:00:00 AM respectively.
• Change back to the current date and time.
• Re-connect any network cables.

I. Shut Down test

• Disconnect any network connections to the computer.
• Quit all open applications.
• Select the "Date and Time" control panel and double-click to open it.
• Type or click on the arrows to set the current date to 12/31/99, and current time to 11:58:00 PM
• Select Shutdown from the Special menu and shut down the machine for more than five minutes,
• Restart the machine.
• Check the current date and current time in the "Date and Time" control panel. It will show 1/1/00, and 12:01:05 AM, respectively.
• Reboot the computer 2 more times and check to verify that the time correctly displays 1 &endash; 1 - 2000.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• Change back to the current date and time.

III. Leap Year Test

• Select the "Date and Time" control panel and double click to open it.
• Type or click on the arrows to set the current date to 2/28/00, and current time to 11:59:00 PM
• Wait for more than one minute, and watch the display update
• The current date and current time in the display will change to 2/29/00, and 12:00:00 AM respectively.
• Year 2000 will be a leap year, so this is perfectly valid.

DOS Machines

If your PC operates from the DOS prompt (C:>) take the following steps:

I. Roll Over test

• Disconnect any network connections to the computer.
• Quit all open applications.
• From the C:> prompt type [date] and press Enter.

The PC will respond with the system date.

• Change the date to 12-31-99 and press Enter.
• From the C:> prompt type [time] and press Enter.

The PC will respond with the system time.

• Change the time to 11:58:00 and press Enter.
• Wait for 5 minutes.
• From the C:> prompt type date and press Enter.
• Note the date that the system returns. It should be 1-1-2000
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• In databases and spreadsheets, create a document with a "date" number type or field type. Verify that the current date is correctly entered.
• Change back to the current date and time.
• Re-connect any network cables.

II. Shut-Down test

Disconnect any network connections to the computer.

• Quit all open applications.
• From the C:> prompt type [date] and press Enter.

The PC will respond with the system date.

• Change the date to 12-31-99 and press Enter.
• From the C:> prompt type [time] and press Enter.

The PC will respond with the system time.

• Change the time to 11:58:00 and press Enter.

Turn the PC off for 5 minutes.

• Restart the machine.
• From the C:> prompt type date and press Enter.
• Note the date that the system returns. It should be 1-1-2000
• Reboot the computer 2 more times and check to verify that the time correctly displays 1 &endash; 1 - 2000.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• In databases and spreadsheets, create a document with a "date" number type or field type. Verify that the current date is correctly entered.
• Change back to the current date and time.
• Re-connect any network cables.

III. Leap Year Test

Disconnect any network connections to the computer.

• Quit all open applications.
• From the C:> prompt type [date] and press Enter.

The PC will respond with the system date.

• Change the date to 02-28-00 and press Enter.
• From the C:> prompt type [time] and press Enter.

The PC will respond with the system time.

• Change the time to 11:58:00 and press Enter.
• Wait for 5 minutes.
• From the C:> prompt type date and press Enter.
• Note the date that the system returns. It should be 2-29-2000
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 2-29- 2000.
• In databases and spreadsheets, create a document with a "date" number type or field type. Verify that the current date is correctly entered.
• Change back to the current date and time.
• Re-connect any network cables.

I. Roll-over test

• Open the Main program group and select Control Panel
• Disconnect any network connections to the computer.
• Quite all open applications.
• Select Date/Time and change the date and time to 12-31-99 and 11:58:00 PM. Click on OK
• Wait five minutes.
• Open the Main program group and select Control Panel
• Select Date/Time and verify that the date and time have changed correctly.
• Reboot the computer 2 more times and check to verify that the time correctly displays 1 &endash; 1 - 2000.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• Change the Date back to the current date and time.
• Re-connect any network cables.

II. Shutdown Test

• Open the Main program group and select Control Panel
• Disconnect any network connections to the computer.
• Quite all open applications.
• Select Date/Time and change the date and time to 12-31-99 and 11:58:00 PM. Click on OK
• Exit Windows and turn the PC off. Wait five minutes and start the PC.
• Open the Main program group and select Control Panel
• Select Date/Time and verify that the date and time have changed correctly.
• Reboot the computer 2 more times and check to verify that the time correctly displays 1 &endash; 1 - 2000.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• Change the Date back to the current date and time.
• Re-connect any network cables.

III. Leap Year test

• Open the Main program group and select Control Panel
• Disconnect any network connections to the computer.
• Quite all open applications.
• Select Date/Time and change the date and time to 2-28-2000 and 11:58:00 PM. Click on OK
• Wait five minutes.
• Open the Main program group and select Control Panel
• Select Date/Time and verify that the date and time have changed correctly.
• Reboot the computer 2 more times and check to verify that the time correctly displays 02 - 29 - 2000.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• Change the Date back to the current date and time.
• Re-connect any network cables.

I. Roll-over Test

• Disconnect any network connections to the computer.
• Quit all open applications. select [Start] then [Settings] [Control Panel] then [Date/Time]. Change the date and time to 12-31-99 and 11:58:00 PM. Click on OK
• Wait five minutes.
• Select [Start] then [Settings] then [Date/Time]. Verify that the date and time have changed correctly.
• Reboot the computer 2 more times and check to verify that the time correctly displays 1 &endash; 1 - 2000.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• Change back to the current date and time.
• Re-connect any network cables.

I. Shutdown Test

Disconnect any network connections to the computer.

Quit all open applications. select [Start] then [Settings] [Control Panel] then [Date/Time]. Change the date and time to 12-31-99 and 11:58:00 PM. Click on OK

Select Shut Down , turn the PC off and wait five minutes and start the PC.

Select [Start] then [Settings] then [Date/Time]. Verify that the date and time have changed correctly.

Reboot the computer 2 more times and check to verify that the time correctly displays 1 &endash; 1 - 2000.

Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.

Change back to the current date and time.

Re-connect any network cables.

I. Leap Year Test

• Disconnect any network connections to the computer.
• Quit all open applications. select [Start] then [Settings] [Control Panel] then [Date/Time]. Change the date and time to 02-28-2000 and 11:58:00 PM. Click on OK
• Wait five minutes and start the PC.
• Select [Start] then [Settings] then [Date/Time]. Verify that the date and time have changed correctly.
• Reboot the computer 2 more times and check to verify that the time correctly displays 02 -29 - 2000.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 02-29- 2000.
• Change back to the current date and time.
• Re-connect any network cables.

I. Roll-over Test

• Disconnect any network connections to the computer.
• Quit all open applications.
• Select [Start] then [Settings], [Control Panel] then [Date/Time]. Change the date and time to 12-31-99 and 11:58:00 PM. Click on OK
• Wait five minutes.
• Select Start then Settings, Control Panel, then Date/Time. Verify that the date and time have changed correctly.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• Change back to the current date and time.
• Re-connect any network cables.

I. Shut Down Test

• Disconnect any network connections to the computer.
• Quit all open applications.
• Select [Start] then [Settings], [Control Panel] then [Date/Time]. Change the date and time to 12-31-99 and 11:58:00 PM. Click on OK
• Select Shut Down , turn the PC off and wait five minutes and start the PC.
• Select Start then Settings, Control Panel, then Date/Time. Verify that the date and time have changed correctly.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 1 &endash; 1- 2000.
• Change back to the current date and time.
• Re-connect any network cables.

I. Leap Year

• Disconnect any network connections to the computer.
• Quit all open applications.
• Select [Start] then [Settings], [Control Panel] then [Date/Time]. Change the date and time to 12-28-2000 and 11:58:00 PM. Click on OK
• Wait five minutes and start the PC.
• Select Start then Settings, Control Panel, then Date/Time. Verify that the date and time have changed correctly.
• Create and save a new document with each application on the computer. Verify that the documented was stored with the creation date set to 02-29- 2000.
• Change back to the current date and time.
• Re-connect any network cables.

Really three problems:

• Use of "2-digit" years: 00 comes before 99! Does this mean 2000 comes before 1999?
• Century years are typically not leapyears (1700, 1800, 1900), but 2000 is a leap year. Did the software developers remember?
• Can your computer hardware handle 2000?

Some standard practices can be a big help:

1. Use date type fields, not text fields.

2. In those date fields, use 4-digit years. That way everyone (including the computer) understands exactly what we are talking about.

3. Stay away from "dummy" dates: 9/9/99, 0/0/00,1/1/11.

4. Use validation routines provided in FMP. Be sure to validate against 4 digit years!

5. Review any instructions you provide for FMP users. Look for "press Return twice", and similar messages. They indicate places where users may be automatically disregarding error messages; Check out those messages!

6. Watch data imports!!! Import data should always use 4-digit years! Different software packages have different "century thresh holds".

7. Corollary: Make someone else's life easier! If you create any export data files to give to someone else, make sure you are giving them 4-digit years!

Steps to check/secure date fields for Y2K in FileMakerPro databases.

Developed using FMP4

Any database that only has a two digit year field and does not use the application's date field/number type is not Y2K compliant. All fields that denote a date should be of the date field type and not text or number fields.

Identify and prioritize all FMP databases:

• Those that will not be in use next fall/winter &endash; we won't bother looking at them.
• Those that will not be in use next fall/winter, but might possibly be used again later.
• Those that will be use next fall/winter.

For each database:

1. Go to the File Menu and select Define, then Fields. In the upper right corner of the dialog box, select View by: Field Type. Click Done.
2. Go back to the File Menu and select Print. In the top of the dialog box select Print: Field Definitions.
3. Using the list printed in the previous step, find all the DATE fields. These are the fields we will focus on.

You may already have date problems!!

Date of Birth fields are particularly suspect. In FMP3 and 4, any date using two digits 00-09 are assumed to be 2000-2009! If you entered '02/14/02' as a DOB, you probably have 02/14/2002 in your database! If you don't believe it, try this: On a blank layout, create a new field called TestDate. Make it a date type. In layout mode, select the field, and using the Format menu, select Date. Choose a date display that uses a four digit year. Now switch back to browse mode and enter '02/14/03'. Check out the year!

Check your dates for problems:

1. Switch to Layout Mode and create a new layout using the Extended Columnar option. You can call it CheckDates.
2. Place all of the date fields on the layout.
3. Select all of the date fields, go to the Format Menu, and select Date. Select a format that displays a 4 digit year. (I use a custom format to get mm/dd/yyyy).
4. Go to browse mode. If you are working with a relatively small database, you can just scan the dates to be sure none of them are in the year 2000.
5. If you are working with large databases, it will be easier to do a multi-request find. Go to Find Mode. Enter '>12/31/1999' in the first date field. Now go to the Mode Menu and select New Request. Copy '>12/31/1999' into the next date field. Continue to add requests until you have the criteria in every date field. Then run your find. If you find no records, you don't have any dates in the 21st century already in your database.

Change your Data Entry forms to display 4 digit years (so users can see what they are really entering).

1. In layout mode, select each date field. Go to the Format Menu, select date, and select or create a format that displays the year in 4 digits. Repeat for each layout used for data entry.

Additional Protection: Limit the range of years that can be entered in a specific field. (i.e. an Admit Date field can be limited to dates between 01/01/1990 and 12/31/2020, or a date of birth must be less than or equal to today.) This is done in the Field Definition Options under validation.

Return To: Top | Y2K Home Page | DHMC Intranet | DHMC Home Page

Class Presentation

Micro-Computer Hardware	Software Programs	Departmental Applications
DHMC Computer Services will test and certify "standard" microcomputer hardware for Y2K compliance. This list includes the following: Mac SE (&30) & Classic I&II Mac II, IIsi, IIci, IIcx, IIfx Mac LC, LCI, LCII, LCIII, LC 475 Mac Q610, Mac Centris 610 Mac 6100 Performa 61xx Mac 7100 Mac 7200 Mac 7300 Apple Printers HP Printers Host Computer Printers HP Vectra VL5 133 & 166 Compaq 4000 Compaq 2000 P90 Compaq DeskPro EN S Compaq Armada 1530 & 1580 IBM ThinkPad 600	DHMC Computer Services will test and certify the following "standard" software programs as Y2K Compliant (Issues will be documented): Word Processing - MS Word 4 & 5.x , Word '95, Word '97 & '98 Spreadsheet - MS Excel 3.x & 4.0, Excel '95, Excel '97 & '98 Database - FileMaker Pro 2.x & 3.0 , v4.0 E-Mail - BlitzMail 2.1 Terminal Emulation - PacerLink (phase out), PacerTerm 3.6 , Smart Term, Host Access Network Installer - LaunchPad 3.1. Virus Protection - Gatekeeper 1.3, Disinfectant 3.6, Norton Anti Virus V3.x, V4.x FTP - Fetch Calendar - Now-Up-To-Date 3.x HTML Authoring - Claris Home 2.0 Web Browser - Netscape Navigator v2.01 & v4.04 Dial-In - ARA (phase out), LinkUp v1.0 & v2.1 Security - At Ease 3.0 & 4.0 Back-up Utility - Retrospect Remote v 4.0 , V3.x Calendar/Scheduling Program - Now Up-to-Date 3.6.x & MS Outlook v8.5	Applications written for Departments by internal staff or third parties will be the responsibility of the Department to Identify Y2K issues. These applications may include: Excel solutions with Macros FilemakerPro Databases Vendor Provided Solutions
Non "standard" micro-computer hardware will be the responsibility of the Department to identify Y2K issues. Computer Services will provide instructions for testing and certifying the hardware.	Non "standard" micro-computer hardware will be the responsibility of the Department to identify Y2K issues.