Caused by: java.sql.SQLException: Year out of range.

Question

Export to Excel. I'm using getdatasubsetdownloadlinkfromrule to get the link to download the excel. The Link work fine if I don't filter the report with Date and Time criteria, if I use ToDate or FromDate in the report Search i get "Error 500 - Internal Server Error". I have a DateTime field in the Table and my Report has Date field which I'm converting to datetime. Error detail attached Caused by: org.hibernate.exception.GenericJDBCException: could not execute query ... ... Caused by: java.sql.SQLException: Year out of range. 
 OriginalPostID-163797 
 OriginalPostID-163797

jeromew · Accepted Answer

Hey kumaraveln. Before converting your dates and datetimes tojson(), you must tostring() them. Then after converting your back fromjson(), you must todate() or todatetime() them. That should fix your issue.

kumaraveln · Answer

Sorry for the late reply. Converting the date to string before passing as JSON worked. Will paste the code here for reference, shortly.

kumaraveln · Answer

Attaching the working code .. Let me know if anyone face any issue .. Report_ExportExcel_Code.txt