|
Wawrzaszek wrote: > Y2K food for thought: > As all companies are doing, we are evaluating what to do for the year > Y2K. We are looking at updating our software to a higher version that > supports 2000, or buying a tool that will convert our existing software. > Both are VERY expensive. This is where an intimate knowledge of your application allows you to choose where to enhance instead of "shot gunning". IMHO not all dates need to be expanded, just the ones that are acted upon and even some of those can be handled with a window technique. For example, in our customer master file we have the date of last sale. One program updates it and a single program uses that information to archive inactive accounts. A windowing technique will work fine for a date of this nature. For the outstanding invoices file, the invoice due date is used in date duration math and for file sequencing so it will be expanded. Our rule of thumb came down to any date which is used for days duration/sequencing is expanded, those dates used for months/years duration are windowed. Informational dates are left alone. (BTW all of our dates are CYYMMDD formatted already so it's a little easier for us then if we had MMDDYY dates) For EDI or download to PC databases you may be forced to expand dates for the needs outside of your 400 applications. You might be able to write bridge programs to handle this instead of modifying your data base and all related programs, but again that is where an intimate knowledge of the application makes you the best judge of which approach to use and the workload required for Y2K readiness. Good luck. P.S. A while back the Dept. of Licensing changed the life of a drivers license and I just renewed mine last August and the expiration date is 082801. The thought occurred to me: Did they change the duration of a license to avoid having any expiration dates mmdd00 and thereby avoiding modifications to any process that chokes on it? Not all solutions require a software change. :) +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to "MIDRANGE-L@midrange.com". | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.