Sudden "UnParsable Date" in a function that has been working fine

Sudden "UnParsable Date" in a function that has been working fine

Hi guys,

I have had the below function running just fine for a couple of months and then on 19th March, for no apparent reason, I noticed a failure with error code: -

UnParsable date at Line Number: 8

When we actually input the date in the field, it's in the format dd-MM-YYYY, so I tried amending, but same error.

The function is as follows.... (for some reason it's messing up the formatting, so the error is actually on line 8, but it's on line 9 below since it's forcing me to leave row 1 blank!....

  2. leadInfo = zoho.crm.getRecordById("Leads",leadId);
  3. leadEmail = ifnull(leadInfo.get("Email"),"");
  4. //start date and time must be a date/time field. Can't work using a date field alone
  5. startDateTime = ifnull(leadInfo.get("Start_Date_Time"),zoho.currenttime.addHour(1));
  6. //assuming you created another field called Start Date/Time. 
  7. startDateTime = startDateTime.toDateTime("yyyy-MM-dd'T'HH:mm:ss'+00:00'").toString("yyyy-MM-dd'T'HH:mm:ss'+00:00'");
  8. //please note that +08:00 is my timezone based on GMT
  9. endDateTime = startDateTime.toDateTime("yyyy-MM-dd'T'HH:mm:ss'+00:00'").addMinutes(30).toString("yyyy-MM-dd'T'HH:mm:ss'+00:00'");
  10. //please note that +08:00 is my timezone based on GMT. Also, if you defined an end date/time field, you can use that instead of hardcoding it like this. Just remember to change the format to ISO using the same method as startDateTime
  11. info "start time: " + startDateTime;
  12. info "end time: " + endDateTime;
  13. meetingTitle = "Viewing";
  14. ownerId = leadInfo.get("Owner").get("id");
  15. eventmap = Map();
  16. eventmap.put("Event_Title",meetingTitle);
  17. eventmap.put("Owner",ownerId);
  18. eventmap.put("What_Id",leadId);
  19. eventmap.put("$se_module","Leads");
  20. eventmap.put("Meeting_Type","Property Viewing");
  21. if(leadInfo.get("Viewing_Type") == "Virtual Viewing")
  22. {
  23. eventmap.put("$meeting_details",{"tool_name":"ZohoMeeting"});
  24. eventmap.put("Meeting_Type","Virtual Viewing");
  25. }
  26. eventmap.put("Start_DateTime",startDateTime);
  27. eventmap.put("End_DateTime",endDateTime);
  28. eventmap.put("send_notification",true);
  29. //put this if you want to send the invitation automatically using the system's defined notification
  30. recipients = list();
  31. recipientMap = {"invited":true,"type":"email","participant":leadEmail,"status":"not_known"};
  32. recipients.add(recipientMap);
  33. eventmap.put("Participants",recipients);
  34. createEvent = zoho.crm.createRecord("Events",eventmap,{"trigger":{"workflow"}});
  35. //the {"trigger":{"workflow"}} is used to trigger any workflow that you have upon the record creation, if any. If not, leave it out
  36. info createEvent;


Thank you in advance for your help.

Best wishes
Rich