Hi

Your to_char and to_char statements are not correct, it should be like this:

TO_DATE(TO_CHAR(SYSDATE, 'dd/mm/yyyy'),'dd/mm/yyyy') - TO_DATE(TO_CHAR(ITEM_DATA.DATE1, 'dd/mm/yyyy'),'dd/mm/yyyy')

Hope this helps 🙂