Re: Date conversion from m/d/ccyy format

[Jeff Young <jyoung0950@xxxxxxxxx>]

Thanks,
I was not sure if %Date would handle that format.
This makes the project easier.




On Thu, Mar 22, 2012 at 9:50 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>wrote:

> Try
>
> D MyDate       S                   D    DatFmt(*ISO)
>  /Free
>   MyDate =  %Date(MDYYFLD: *USA);
>   Dsply Date;
>  /End-Free
>
> 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 Jeff Young
> Gesendet: Thursday, 22. March 2012 14:30
> An: rpg400-l@xxxxxxxxxxxx
> Betreff: Date conversion from m/d/ccyy format
>
> All,
> I have a project where I will be receiving a csv file from an external
> system.
> The dates will be formatted as m/d/ccyy (including separators).
> ie:3/5/2012,3/1/2012,10/1/2012.....
>
> I need to convert them to ISO format.
> Can I use the %Date BIF to convert them?
> If not what is the best method?
>
> Thanks,
> --
> Jeff Young
> Sr. Programmer Analyst
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.