|
Glenn With several years in the business and one huge Y2K project under my belt, I can not understand why anyone would populate their database with false representation of dates. Updating the dates with -28 years locks you into perpetual date manipulation in all new programs, external file transfers, SQL, Query, Excel ETC, ETC. If the argument is speed of remediation, there are tools which insert programming right before a date representation on screens and reports which take the date from CYMD to MDY or DMY. They also do the reverse when comparing file and screen values or updating screen values into the file. What is the difference between this and having code inserted into every program which adds and subtracts 28 years to every date field in a record. As a bonus, dates in the files will contain real values. My experience is with 405CD in a heavily modified installation with over 3000 programs. I do not have experience with +/- 28. Have I missed the concept? I would appreciate any feedback and dialogue. Ardi >From: Glenn Ericson <Glenn-Ericson@att.net> >Reply-To: BPCS-L@midrange.com >To: BPCS-L@midrange.com >CC: MKLBOURDIN@wanadoo.fr (Michael BOURDIN) >Subject: Re: Y2K tools for BPCS 5.1 >Date: Tue, 14 Sep 1999 15:52:01 -0400 > ><< attach1 >> ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.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.