SQL Problem Coverting from Numeric YYYYMMDD to a Date Format

I am trying to create a view that automatically displays only 1 year's worth
of data. The problem is that the dates are in a numeric YYYYMMDD format.
What is the easiest why to convert to a date format?

This is what I am trying now and doesn't work.:
CAST(CONCAT(CONCAT(SUBSTRING(CAST(ncmplntdt as char),1,4), '-'),
CONCAT(CONCAT(SUBSTRING(CAST(ncmplntdt as char),5,2), '-'),
SUBSTRING(CAST(ncmplntdt as char),7,2))) AS DATE) as ncmplntdt

The always helpful IBM error is "Argument 1 of function *N not valid."

I am sure there has to be an easier way. We are on V5R3.