Type mismatch -- date error

See more:

Javascript

Hi,

I am currently experiencing the following error --> Type mismatch. Value 19/5/2014 does not match type datetime in column index 3.

function drawVisualization(dataValues, chartTitle, columnNames, categoryCaption)
{
   if (dataValues.length < 1)
      return;

   var data = new google.visualization.DataTable();
   data.addColumn('string', columnNames.split(',')[0], 'Name');
   data.addColumn('number', columnNames.split(',')[1], 'Price');
   data.addColumn('string', columnNames.split(',')[2], 'Price Type');
   data.addColumn('datetime', columnNames.split(',')[3], 'Date');

   for (var i = 0; i < dataValues.length; i++)
   {
      var date = new Date(parseInt(dataValues[i].Date.substr(6), 10));

      //Convert variable to date value
      //var date = new Date(parseInt(dataValues[i].Date.substr(6), 10));
      //var date = new Date("2013/12/19");

      //Set the format of Date to dd/MM/yyyy
      var newDate = date.getDate() + '/' + (date.getMonth() + 1) + '/' + date.getFullYear();
      alert(newDate)

      data.addRow([dataValues[i].ColumnName, dataValues[i].Value, dataValues[i].Type, newDate]);
   }
}

I am little unsure, how to go about solving this issue. if someone could direct me in the right direction, please. many thanks.