Lakshay
Databricks Employee
Databricks Employee

Hi @vikram sinhha​ , The issue is happening because the input you are providing is not a valid date format. to_date expects you to provide the correct date format. You need to add the date value to the mon-yr column before passing to to_date function