RE: Date range

Better to spend the time to "fix" the dates to 8 byte numerics or
preferrably a true date field & prevent the misery that will come later.
Convince them that they may be facing another Y2K type deal in the
future if it doesn't get done...it's far better to spread the cost over
a period of years than one huge frigging chunk at one time... 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx] On
Behalf Of Wayne McAlpine
Sent: Thursday, December 07, 2006 8:50 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Date range

Hey, by the time 2039 rolls around, someone will have figured out how to

handle it.  Won't they??

Johnny Johnson wrote:

What's odd though, is that if you look at a true *MDY date type the

low

value is 01/01/40 and the hi value is 12/31/39.  We know this means

1940

through 2039, but it could really be confusing, and possibly

disastrous, if

using *MDY dates as ranges.

Johnny Johnson
Hub Group, Inc.

             "Michael Ryan"

             <michaelrtr@gmail

             .com>

To 

             Sent by:                  "RPG programming on the AS400 /

             rpg400-l-bounces@         iSeries"

<rpg400-l@xxxxxxxxxxxx>    

             midrange.com

cc 

Subject 

             12/07/2006 08:38          Re: Date range

             AM

             Please respond to

              RPG programming

              on the AS400 /

                  iSeries

             <rpg400-l@midrang

                  e.com>

Our friend Mr. Manual can!

Number of Digits in Year                                         Range

of

Years
2 (*YMD, *DMY, *MDY, *JUL)                            1940 to 2039
3 (*CYMD, *CDMY, *CMDY)                               1900 to 2899
4 (*ISO, *USA, *EUR, *JIS, *LONGJUL)             0001 to 9999


On 12/7/06, Douglas Palme <dpalme@xxxxxxxxxxx> wrote:

Can someone tell me what the max range is for a MDY date? IE: 1900 -

2020

Some of our programs still use six digit dates (Yes, I know we should

be

converting them but that's not my decision and considering the number

of

programs involved it would take a huge amount of time and resources)

and

I

need to trap for max dates that are allowable in a *USA format but

are

invalid for a *MDY

************************************************************************
****

This transmission may contain information that is privileged,
Confidential and/or exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that
any disclosure, copying, distribution, or use of the information
contained herein (including any reliance thereon) is STRICTLY
PROHIBITED. If you received this transmission in error, please
immediately contact the sender and destroy the material in its
entirety, whether in electronic or hard copy format. Thank you.

************************************************************************
****

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.