Re: AW: How to convert DD/MM/AAAA to date

Exactly - his format is MM/JJ/AAAA - that is French for MM/DD/YYYY - I don't know the French for "month", but it must start with "M" - "J" means "jour", as David said, which is "day", and "A" has to be something like "annes" for "year"

So that is the *USA format - the source supplying the data must be American!

Vern

On 8/3/2010 8:53 AM, Birgitta Hauser wrote:

That is the *USA format, I believe - you can convert it to a date in RPG

But USA Format is MM/DD/YYYY while the European format is DD.MM.YYYY.
In this way make sure where the month and day are positioned, before
converting them!!!

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Vern Hamberg
Gesendet: Tuesday, 03. August 2010 15:44
An: RPG programming on the IBM i / System i
Betreff: Re: How to convert DD/MM/AAAA to date

David

That is the *USA format, I believe - you can convert it to a date in RPG
like this

%date(datefield : *USA)

See if that works

Vern

On 8/3/2010 7:32 AM, David FOXWELL wrote:

Oops, sorry, I've been away.

Forgot to translate JJ means DD ( jour )

Any idea Birgitta, how they ( the company that sent the file ) would have

got all those dates filled in that way?

Thanks!

-----Message d'origine-----
De : David FOXWELL
Envoyé : mardi 3 août 2010 13:39
À : 'RPG programming on the IBM i / System i'
Objet : How to convert DD/MM/AAAA to date

Hi all,

I have a 10A field with the date filled like DD/MM/AAAA.
If I do SELECT char(datefield) FROM mytable it shows the date
as MM/JJ/AAAA.


I need to read the file in an RPG and pass the 10A field as a
date to an external procedure.

MONITOR;
mydate = %DATE ( datefield : *EUR );
ON-ERROR;


I'm getting an error on each conversion. If I change the / to
a . in the file, the conversion is ok.

What should I do?

Thanks.