Google Table Chart: Date Format -


i returning data chart using json. i've managed format date x-axiz of line chart, using;

var options = {             haxis: {                          format: ' dd mmm yy'                     }, } 

but need doing same table chart 1 of columns should of date format.
at moment displaying "/date(1372761341103)/" how format option? understand it, "options" variable setting not available table chart. also, when add columns, setting 'date' column's data type 'date' doesn't work...no chart returned.

this code currently:

         function drawchart3() {           $.get('/mymall/getadrundata', {},             function (data) {                  /* add data */                 var tdata = new google.visualization.datatable()                 tdata.addcolumn('number', 'id');                 tdata.addcolumn('string','date');                 tdata.addcolumn('number', 'opens');                  (var = 0; < data.length; i++) {                     tdata.addrow([data[i].id, data[i].date, data[i].opens]);                 }                  /* draw chart */                 var chart = new google.visualization.table(document.getelementbyid('chart_adrun'));                 //var formatter = new google.visualization.colorformat();                 //var monthyearformatter = new google.visualization.dateformat({ pattern: "mmm yyyy" });                 monthyearformatter.format(tdata, 0);                 formatter.addrange(-1, 1, 'white', 'orange');                 formatter.addrange(0, 2, 'red', '#33ff33');                 formatter.addrange(1, 10, 'red', 'pink');                 formatter.format(tdata, 1); // apply formatter second column                 chart.draw(tdata, { allowhtml: true, showrownumber: false });             }          )       } 

i solved way...

                    (var = 0; < data.length; i++) {                     var date = new date(parseint(data[i].date.substr(6)));                     tdata.addrow([data[i].id, date, data[i].opens]);                 } 

Comments