Date and datetime fields formatting and wrong data type issue when update or create
Hello,
I'm trying to update a field in the Potentials module;update a datetime field with a date field value. But, I'm getting the error below.
Code below:
// get Deal records
dealDetails = zoho.crm.getRecordById("Potentials",dealID);
// get site survey schedule date
site_survey_date = dealDetails.get("Site_Survey_Schedule_Date_2");
update_date = zoho.crm.update("Potentials",dealID,Map:String({"test_datetime":site_survey_date}));
Error below:
{"code":"INVALID_DATA","details":{"expected_data_type":"datetime","api_name":"test_datetime"},"message":"invalid data","status":"error"}