pcawdron, here is another way. I think it's a good way to do it.<br><br>SELECT CLAIM_NUM <br> , CLAIM_EFF_DATE <br> , CURRENT DATE - CLAIM_EFF_DATE <br> , YEAR(CURRENT DATE - CLAIM_EFF_DATE) <br> , MONTH(CURRENT DATE - CLAIM_EFF_DATE) <br> , DAY(CURRENT DATE - CLAIM_EFF_DATE) <br> , (YEAR(CURRENT DATE - CLAIM_EFF_DATE) * 12) <br> + MONTH(CURRENT DATE - CLAIM_EFF_DATE) <br>FROM DB2.TABLE <br>WHERE AREA_NO = 999 AND <br> CLAIM_EFF_DATE BETWEEN '1950-01-01' AND CURRENT DATE<br>ORDER BY 3<br><br>Query result run on 2000-07-19<br><br><br> CLAIM<br>CLAIM EFF DATE<br> NUM DATE DURATION YEARS MONTHS DAYS # OF MON<br>------ ---------- ----------- ----- ------ ----- -----------<br> 65401 2000-06-30 19 0 0 19 0<br> 1344 2000-06-28 21 0 0 21 0<br>123415 1999-12-30 620 0 6 20 6<br> 25753 1999-08-02 1117 0 11 17 11<br> 3616 1999-07-19 10000 1 0 0 12<br> 5575 1986-11-17 130802 13 8 2 164<br> 14181 1984-03-04 160415 16 4 15 196<br><br> <br>I hope this makes it easier for you. Let me know<br>