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

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

> > 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.
> >
> >
> >