Just to clarify. After the extract has been taken, the datediff function is not recognized? Is there an error thrown?
I should have mentioned that the extract does not take with the DATEDIFF function. There is an error, and it states:
"[IBM][System i Access ODBC Driver]Communication link failure. comm rc=8405 - CWBCO1047 - The System i server application disconnected the connection
Unable to create extract"
I think the server disconnects the connection because it doesn't know what to do with the calculated date field within the DATEDIFF calculation. Thanks!