jquery - select the data between two dates from a json data -
i have json file data as,
[ [1,622,782,783,"2015-04-21"], [2,622,782,783,"2015-04-21"], [3,622,782,783,"2015-04-22"], [4,622,782,783,"2015-04-23"], [5,622,782,783,"2015-04-24"], [6,622,782,783,"2015-04-28"], [7,622,782,783,"2015-04-28"], [8,622,782,783,"2015-04-29"], [9,622,782,783,"2015-05-04"], [10,622,782,783,"2015-05-05"] ]
how can select/load values between dates 2015-04-23
, 2015-04-28
?
quick option here:
var data = [ [1, 622, 782, 783, "2015-04-21"], [2, 622, 782, 783, "2015-04-21"], [3, 622, 782, 783, "2015-04-22"], [4, 622, 782, 783, "2015-04-23"], [5, 622, 782, 783, "2015-04-24"], [6, 622, 782, 783, "2015-04-28"], [7, 622, 782, 783, "2015-04-28"], [8, 622, 782, 783, "2015-04-29"], [9, 622, 782, 783, "2015-05-04"], [10, 622, 782, 783, "2015-05-05"] ]; var fromtime = new date("2015-04-23").gettime(); var totime = new date("2015-04-28").gettime(); var filtereddates = []; var row, date; (i in data) { row = data[i]; date = new date(row[4]); if (date.gettime() >= fromtime && date.gettime() <= totime) { filtereddates.push(row); } } var results = document.queryselector("#results"); // debugging results.innerhtml = json.stringify(filtereddates); // debugging
<div id="results"></div>
Comments
Post a Comment