Re: Year 2K - how to shake down your system

[DAsmussen@xxxxxxx]

Wayne,

In a message dated 97-08-15 20:57:10 EDT, you write:

> >>DAsmussen@aol.com wrote:
>  >>> 
>  >Would you believe, I know a company !-) that has separate fields for
year,
>  >month & day?

(Actually, I didn't write that -- it was the original poster)

>  Am I being dense? That sounds like a good place to be! 
>  The database can be changed to include century fields without changing any
>  of the existing code.
>  All of the year fields have names that can be easily scanned for.
>  I'll bet that much of the date formatting is done in data structures --
>  again easily scanned and centralized in a copy member if you're feeling
>  ambitious.

Well, the software overhead is horrendous, and queries are MUCH larger than
they need to be.  Not to mention the fact that third-party query tools or
EIS's will not perform at optimum under these circumstances.  How do you
figure that the database can be changed without code changes, given sort
criteria and all?

>  It's the databases(?) that have dates stored in 47 different formats that
>  leave me feeling chapped.

And why would month, day, year storage have any impact on THIS?  Older
applications are still bound to have things stored in both MDY and YMD
format, and sorts will still have to be modified to include the century...

JMHO,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"In America, anyone can become President.  That's one of the risks you take."
-- Adlai Stephenson
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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 MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *