Re: Year 2000

[Mark Lazarus <mlazarus@xxxxxxxx>]

Susan,

At 10:22 AM 6/5/97 -0500, you wrote:
>We are gearing up to do our Year 2000 conversion. What we have decided
>so far is that:
>
> 1) We will be expanding our files to include the 
>century in all date fields; and
> 2) On all screens and reports, we will leave the date as a 6 digit
>representation (unless an exception is absolutely necessary).
>
>We are considering purchasing a tool by Advanced Systems Concepts
>called Century Update, which provides analysis and conversion
>functionality.
>
>Our greatest debate is whether or not to use native dates or to
>go to an 8 digit numeric YYYYMMDD for our file date fields.
>
>Any suggestions, advice, horror stories, etc. would be appreciated.

 IMHO, since you are changing your DB, use the date data types.  It will
make it a lot easier for future projects in several areas, most notably when
using Query or SQL.

 This also assumes that you will convert your code to RPG IV, since RPG
III/400 is not as easy to work w/ the date data types.

 -mark

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