Re: 3 Months Ago? -- RPG400-L

× 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.

The point is you are subtracting "months" not days. It self adjusts the day of
the month to ensure it is a valid date.

As Bob puts it, use a different method to calculate 3 "calendar" months which
could equate to 89 to 91 days depending on the span, then you are subtracting
"days".

Good Luck
Bill
(All else fails READ THE INSTRUCTIONS)

----- Original Message ----
From: Booth Martin <booth@xxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Thursday, May 17, 2007 9:39:50 AM
Subject: Re: 3 Months Ago?

What bothers me is that dates don't round trip well. Does March 31st
less one month, plus one month, equal March 31st?

Wilt, Charles wrote:

RTFM....

"When subtracting a duration in months from a date, the general rule is that
the
month portion is decreased by the number of months in the duration, and the
day
portion is unchanged. The exception to this is when the resulting day portion
would exceed the actual number of days in the resulting month. In this case,
the
resulting day portion is adjusted to the actual month end date."

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.