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

May be with SQL?

Replace(Char(MyDate, *EUR), '.', '/')
Digits(MyDay) concat '/' concat Digits(MyMonth) concat '/' concat
Digits(MyYear)

Or with an homegrown RPG function or subroutine?

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 David FOXWELL
Gesendet: Tuesday, 03. August 2010 14:32
An: RPG programming on the IBM i / System i
Betreff: RE: How to convert DD/MM/AAAA to date



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.