I am trying to construct an SQL statment and pass it to an i5. However I keep getting the above error message. At its simplest I am trying to convert an 8 0 numeric field in the format 20070817 to a date so that I can subtract a number of days. The statement consists of:

Cast((SUBSTR(CH AR(OHDATE),7,2) ||'/'|| SUBSTR(CHAR(OHD ATE),5,2) ||'/'|| SUBSTR(CHAR(OHD ATE),3,2)) As date)

I have also tried:

Date(SUBSTR(CHA R(OHDATE),7,2)| |'/'||...