|
That's right Jon, because we all know the "best" way to convert numeric fields that contain dates is by multiplying them by 10000.01 or 100.0001 <TIC> Bob Cozzi Cozzi Consulting www.rpgiv.com -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris Sent: Wednesday, August 27, 2003 1:05 PM To: rpg400-l@xxxxxxxxxxxx Subject: RE: dates in /free >> What is the best way in rpgle/free to convert a date in a 6 digit numeric field from ymd to mdy? I'm not sure the word "best" applies but at V5R2 you can do this: mdy = %Int(%Char (%Date (ymd: *YMD): *MDY0) ); >> Also, how can I use the TEST opcode in rpgle/free to test a date in a 6 digit numeric field? You can't. Your best bet is to use MONITOR like so: D mdy s 6 0 D ymd s 6 0 /Free monitor; mdy = %Int(%Char (%Date (ymd: *YMD): *MDY0) ); on-error; // catch bad date // do whatever you do with a bad date endmon; Jon Paris Partner400 www.Partner400.com _______________________________________________ This is the RPG programming on the AS400 / iSeries (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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.