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

What should I do?

What you already do!
Replace the slashes with dots and convert the result. Or remove the slashes
and convert the result.

For 4 digit year formats the date separators are fixed and cannot be
changed. Date format *EUR uses the dot, *USA uses the slash and *ISO uses
the dash. Only for 2 digit year formats the date separator can be choosen.

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 13:39
An: RPG programming on the IBM i / System i
Betreff: 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.