Rob,
Good link, I'll have to check it out, see how I might be able to incorporate into my various routines.
For how much we all love the "I" why did IBM decide to store dates MDY.
Life would be so much simpler if they were all YMD.
In fact, isn't one of the basic rules of data base, store dates in CYMD format, for a multitude of reasons (sorting, comparing, etc)
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, February 11, 2015 11:25 AM
To: Midrange Systems Technical Discussion
Subject: Re: Object Last Use Date MDY compare issue
IDATE?
http://www.think400.dk/downloads.htm
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 02/11/2015 11:01 AM
Subject: Object Last Use Date MDY compare issue
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
I frequently need to compare object last use dates.
Some IBM output files QAEZDISK (use YMD while others (DSPOBJD, DSPFD) use
MDY.
When MDY is used, I'm constantly breaking up the LUD into individual work
fields, MM, DD, YY and then concatenating them back together with the
century for the object date compare.
ODCDATCYMD ODCCEN || ODCDATY || ODCDATM || ODCDATD
Is there a better or easier way of accomplishing this?
Thank You
_____
Paul Steinmetz
IBM i Systems Administrator
Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071
610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home
psteinmetz@xxxxxxxxxx
http://www.pencor.com/
midrange.com
