Re: Two digit date window

["Peter Dow" <pcdow@xxxxxxxxx>]

Hi Jon,

You've got a point, but again, you still have the correct date in your
database. That becomes part of the user-training issue <VBG>.  You have the
same problem with the current window of 1940-2039 -- what if you try to
convert a date from the 1930's with DATFMT(*MDY)? Do you get 2030? Or an
error, as I would expect?

Regards,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

From: <Jon.Paris@hal.it>
>  >> 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 the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---