Re: MIDRANGE-L Digest V4 #371

Actually, if he wanted to match values with Excel for all date ranges,
some logic would be required also.

use base date 12/31/1899 and do SUBDUR.
If date is > 2/28/1900 add 1 to value.

Then Excel and this value would match in all cases.

What a kludge.

Regards,

Jim Langston

Date: Fri, 13 Apr 2001 10:10:23 -0500
From: "Falconberry, Ron" <PGRGF@mail.directins.com>
Subject: RE: Serial Date formula

So, since Excel recognizes 02/29/1900 as valid, but the AS/400 does not, it
would appear that there are two answers to the  original writer's question
about obtaining a date value for 03/18/2001:

1. If he wants to match the Excel value of 36968, he needs to use 12/30/1899
as the base date in his SUBDUR statement.  Any date value greater than
02/28/1900 would produce the identical value as Excel.

2. If he wants an accurate date value, use 12/31/1899 as the base date in
his SUBDUR statement.  Excel and the AS/400 will match for the first 59 days
of 1900 but, after that, they will be off by a day.

Is anyone else concerned, like me, that if Excel can be off on a simple date
calculation, what other errors might be hidden in that, or other MS,
packages?

Ron
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---