dates from MySql not converting correctly

My test data in MySQL contains datetime fields that show values as YYYY-mm-dd HH:ii:ss, but the dates showing in the Gantt chart are not right. For instance 2014-07-23 00:00:00 is displayed in the Gantt chart as 1929-01-03. How do I make the date come across correctly?

set gantt.config.xml_date before data loading

docs.dhtmlx.com/gantt/api__gantt … onfig.html

Thank you. I had that line in the code previously, but must not have written it correctly. It is now working as it should.

   gantt.config.show_progress = true;
   gantt.config.xml_date = "%Y-%n-%d %H:%i"
   gantt.config.fit_tasks = true;
   gantt.config.scale_unit = "month";
   gantt.config.date_scale = "%F %m";
   gantt.config.min_column_width = 50;
   gantt.config.scale_height = 54;
   gantt.config.subscales = [
        { unit: "day", step: 1, date: "%m:%d" }
        ];

   gantt.init("gantt_here");
   gantt.load('data.php');