What SQL statement should I use to return data from table F4111 in a date range of current date to previous year? Creation date column ILCRDJ in table F4111 holds a date entry that is a text string (ie: "06/14/26"). I am using an ODBC server and trying to use SQL statement to return by parameter. Here is an attempt and the error message received.
SELECT *
FROM F4111
WHERE ILCRDJ >= {fn CURDATE()-365}
"ODBC: ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0182 - A date, time, or timestamp expression not valid."
