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

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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