Re: Two digit date window

[Glenn Ericson <Glenn-Ericson@xxxxxxx>]

Jon
1939 or 1927  or 28 and below go Boom too under  the 1940- 2039
theory

All windows are only as stable  as  their internal pivot year
relates to the dates received for processing. YES/NO?


At 06:30 PM 06/15/2001 -0400, Jon.Paris@hal.it wrote:

>  >> Now if you're still storing
> years as 2-digits in your database, and
> depending on the window to determine the century, *then* you've got
> a
> problem if the window changes.
>
> "still storing ..." - what about those folks who decided to
> implement
> "real" dates in the database?  The value is stored as a
> number of days (so
> the full 4 digits are there) but if I chose to use DATFMT(*MDY) when
> I
> defined the database then I'm in trouble if the system changes the
> window.
> Right now any dates in the 1940 - 2039 range are valid as *MDY and
> work
> just fine - but if the window changes to (say) 1960 - 2059 then if I
> read
> one of those records with a date in the 1950s then 
> "boom".
>
> This is why I said I thought it would need new DATFMT options - I
> don't
> believe you can just change the meaning of the existing ones.
>
> Jon Paris
> Jon.Paris@e400.com
>
> www.e400.com - A new
> wave of iSeries and AS/400 Education
>
> +---


Glenn
________________________
Glenn Ericson,    
Phoenix Consulting LLC ,  New York , NY USA
Ph.(718)898 9805  Fx .(718)446 1150
mailto:Glenn-Ericson@att.net
__________________________