|
>Date: Wed, 17 May 2000 15:13:05 -0700 >From: "Gary Kuznitz " <docfxit@calwest.net> > >I can't figure out why I'm getting an error when using SUBDUR to >calculate the number of years between two dates. I'm starting out >with > 02/20/39 in BIRTHDATE > 02/18/80 in JDATE > >I end up with 59 in AGEATHIRE >It should end up with 40 years. Does anyone know why it's wrong and >what I can do to correct it? You had me going there for a minute, Gary... 02/20/39 = Feb 20 2039, 02/18/80 = Feb 18 1980. 2039 - 1980 = 59. The range of *MDY is 1940 - 2039, so if you want 39 to mean 1939, you have to use dates with 4-digit years. Barbara Morris +--- | 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 +---
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.