I need your assistance.
I have the below code in a query but I get the an error due to date formatting.
Can anyone please help?
when to_date(:p_Enter_Date,'DD/MMM/YY') - MAX(st.sales_date) > 180 –180 days
END as Late_Sales_Payment
ORA-01821: date format not recognized
01821. 00000 - "date format not recognized"