I have a JSON array in a local file called data.json, looks the following:
[
{
"id":"1",
"priority": "P1",
"start_date": "2021-01-01 14:40:33"
},{
"id":"2",
"priority": "P2",
"start_date": "2019-01-01 14:40:33"
},{
"id":"3",
"priority": "P3",
"start_date": "2020-01-01 14:40:33"
},{
"id":"4",
"priority": "P2",
"start_date": "2020-01-01 14:40:33"
},{
"id":"5",
"priority": "P1",
"start_date": "2021-01-01 14:40:33"
}
]
I'm trying to get total count set by two conditions as seen below, however the formatting on the start_date YYYY-MM-DD HH-MM-SS is static and can't be changed, I want to be able to look for the first 4 digits only (the year) but still unable to, any toughts?
import data from "./data.json" assert{ type: "json" };
var count = 0;
for (var i = 0; i < data.length; i++) {
if ((data[i].priority === 'P1') && (data[i].start_date === "2021")) {
count++;
}
}
console.log(count)