SQL as400 query to see who is 70.5 years old this year
===

I am trying to find individuals that will turn 70.5 years old in the current year.

dob7 = DECIMAL(7)  dddyyyy

    select acctno, name, address, status, year(curdate()) - year(date(digits(dob7))) as Age
    from mydata.cdmast cdmast
    left join mydata.cfmast cfmast
    on cdmast.cifno = cfmast.cifno
    where status <> 'R' and year(curdate()) - year(date(digits(dob7))) >= 70

The following returns error:  [Error Code: -181, SQL State: 22008]  [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0181 - Value in date, time, or timestamp string not valid.

Thank you in advance.