Gannt Lightbox open error

Gantt
#1

I am trying to edit a task and get this error. I have 3 other date fields other that start and end. It seems when any of them have a date I get the error pictured below. For the life of me I can not figure out what to do next.
Let me know if you need anything else.

Thanks in advance for any help.

I set:
gantt.config.xml_date = “%Y-%m-%d %H:%i:%s”;

I am using MySql datetime field for all date columns some are null and some are populated.

I am using this function to display the data in the console:

gantt.attachEvent(“onBeforeLightbox”, function (id) {
var task = gantt.getTask(id);
console.log("id = ",id);
console.log("task = ",task);
console.log("task.strt_date = ",task.start_date);
console.log("task.end_date = ",task.end_date);
console.log("task.lm_actual_startdate = ",task.lm_actual_startdate);
console.log("task.actual_delivery_date = ",task.actual_delivery_date);
console.log("task.work_package_req_approval_date = ",task.work_package_req_approval_date);

return true;

});

Capture3
Capture31424×672 44.9 KB

#2

Hi @RonM ,
As I understood you have additional lightbox time sections and problems to change its values.
start_date and end_date are the date type object.
lm_actual_startdate, task.actual_delivery_date, work_package_req_approval_date are the string type values and you need to convert it to date object.

https://docs.dhtmlx.com/gantt/desktop__date_operations.html#convertingastringtoadateobject

You can do it in onTaskLoading event.
https://docs.dhtmlx.com/gantt/api__gantt_ontaskloading_event.html

Here is a sample, where you can see how it can be implemented :

1 Like
#3

Hi guldmi,

Thanks for the reply. The 3 extra time fields are defined as datetime in the MySql database so they should not be strings. I will look at what you suggest and hope I find a solution.

Thanks again for the help.

RonM

#4

guldmi,

That worked like a charm! Thank you for your time and reply.

1 Like