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

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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