Re: Year 2000

Al,

In a message dated 97-06-07 15:30:15 EDT, you write:

> The problem with date data types is more than performance.  Zero dates are
>  special values are not supported.  Also invalid dates blow up.  How clean
>  is your data?  Do you have a field in your A/R system for 'date paid'? Do
>  you have a field in your payroll system for 'date of termination'?
>  
>  It's not that straight forward.

Now THIS is the sort of information that I was looking for on this subject!
 As I mentioned before, performance was an afterthought.  BPCS allows zeroes
as a beginning effectivity date on a bill of material, with all 9's as an
end.  From what you stated, I'd assume that date fields are out of the
question for us...

Thanks!

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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *