RE: Determine birth date 6s0 format

Honestly,

You can't do this with 100% success....

Suppose you get the following: 080215

Is that 2008-02-10, which could be the birth date of my daughter...

Or 1908-02-10 which could be the birth date of my Great-Grandmother (yes she just turned 100. I've got
a nice picture of her holding my new daughter :)

Why is it that 8 years after Y2K, you're still getting 6 digits dates?

Charles Wilt
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of DLee@xxxxxxxx
Sent: Friday, May 09, 2008 11:55 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Determine birth date 6s0 format

Could use some help;

My client is sending a file of birthdates and loan effective dates in
mmddyy format;

For example:

A birth date of 062337 translates to 2037/06/23 Common sense dictates
this is not a valid birth date and would be 1937/06/23

Below Char_Date = 062337 and translates to 2037-06-03 in ISODATE.

What would be best practice for handeling this problem?

C *MDY TEST (D) Char_Date
19
C IF *IN19 = *OFF
C *MDY MOVE Char_Date ISODATE

Appreciate your help

Yeah I know, fixed format. Brr sldkfhgj

Darrell Lee
Information Technology
Extension 7127
--
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 e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.