• Subject: RE: ILE Question
  • From: Chris Bipes <rpg@xxxxxxxxxxxxxxx>
  • Date: Tue, 16 Nov 1999 14:06:20 -0800

On your subdur use the *M to retrieve the months.  Your result field should be large enough to hold the years * 12 + months.  Then divide by 12 to get the years and move the remainder to your months field.
-----Original Message-----
From: Jim Waymire [mailto:jimwaymire@pacificnet.net]
Sent: Tuesday, November 16, 1999 11:23 AM
To: midRANGE-L@midrange.com
Subject: ILE Question

I am trying to arrive at years and months on a subdur of date of employment to current date.  I can do *y or *m, but how can I get a breakdown of both years and months. 
Also, it only seems to work if I use a 2 digit field for the months, and for employment, I would need greater than 2 digits.
 
Any help would be appreciated.
 
Jim Waymire

This thread ...


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

This mailing list archive is Copyright 1997-2019 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].