× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Eric,

I agree that the ideal would be using a proper date field and format (not
very sure if that includes the *USA format :-) ) but, in this case, Rob
presented a business problem, and I was trying to offer a solution based on
those constraints.

Best Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Fri, Jun 4, 2010 at 12:26 PM, DeLong, Eric <EDeLong@xxxxxxxxxxxxxxx>wrote:

Egad! Can we just encourage everybody to just use a safe format
already? Why another workaround? We've wasted hundreds (thousands,
millions) of IT hours trying to work around the limitations of six-digit
date formats... I don't buy into the old argument that entering the
century portion of a date slows the clerks down. A 30yr mortgage, being
a financial instrument, would probably benefit from un-ambiguous date
formats. In my experience, expecting a customer to instinctively know
that 06/04/40 means '06/04/2040'(*USA) or '2040-06-04'(*ISO) is a fool's
errand.

-Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Friday, June 04, 2010 11:20 AM
To: Midrange Systems Technical Discussion
Subject: Re: 30 year mortgage vs Y2K

I suppose that changing those values can result in compatibility
problems
for a lot of shops. Maybe submitting a DCR with the suggestion of
including
a *DTAARA for the year range would help. That said, maybe the fastest
solution would be creating your own CVTDAT command with the already
mentioned *DTAARA. If present or value <> 40 , run your code. If not,
run
the old cmd.

HTH,

Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries


On Fri, Jun 4, 2010 at 11:08 AM, <rob@xxxxxxxxx> wrote:

Ok, some company tried using the technique below:

From the help on CVTDAT on 7.1
Only valid dates can be converted. If either the from-format or the
to-format use only 2 digits to specify the year (for example, *MDY,
*DMY, *YMD, or *JUL), valid dates are in the range of January 1,
1940, to December 31, 2039. Otherwise, valid dates are in the range
of August 24, 1928, to May 9, 2071. If the year is specified with
only 2 digits, years in the range of 40 to 99 are assumed to be 1940
to 1999; years in the range 00 to 39 are assumed to be 2000 to 2039.
The command works in conjunction with the QLEAPADJ system value.

However, 30 year mortgages are now hitting that wall.

Yes, they should use real date fields.

Any place to set a sliding scale to move that up a bit until they fix
it?
Like change the cutoff from 40 to 50 or 60?



Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.