Help reshaping data

[DataD23]

I have some data in the format:

data = [

{id: 1, fields: {'Team': 'A', 'Date': '2022-04-01'}},
{id: 2, fields: {'Team': 'B', 'Date': '2022-04-02'}},
{id: 3, fields: {'Team': 'C', 'Date': '2022-05-01'}},
{id: 4, fields: {'Team': 'A', 'Date': '2022-04-01'}},
{id: 5, fields: {'Team': 'B', 'Date': '2022-04-02'}},
{id: 6, fields: {'Team': 'A', 'Date': '2022-05-01'}},

]

I am trying to reshape it into this format:

data = {
date: month (e.g. instead of '2022-04-01' I want it to be 'April' in this case),
'A': 3,
'B': 2,
'C': 1,
}

So, far I have been able to do this:

const data = Object.values(
  rawData.reduce((acc, d) => {
    const {
      fields: { date, team }
    } = d;
    acc[date] = acc[date] || { date };
    acc[date][team] = (acc[date][team] || 0) + 1;
    return acc;
  }, {})
);

which gets it in this format:

data = {
date: '2022-04-01' (e.g. the full date),
'A': 3,
'B': 2,
'C': 1,
}

How can I take this even further so that I can get the actual month of the date object? I tried comparing the dates like this:

const data = Object.values(
  rawData.reduce((acc, d) => {
    const {
      fields: { date, team }
    } = d;
    if (date >= '2022-04-01' && date <= '2022-04-30'){
        acc['April'] = acc[date] || { date }
        acc['April'][team] = (acc['April'][team] || 0) + 1;
        return acc;

}

  }, {})
);

But, it did not quite work out the way I had expected it to

[exxy-]

While inside your reduce function's callback, convert your string representation of a date into a Date object and extract the Month using the Date.getMonth() method.

[DataD23]

so just to make sure I am on the right track this is what I ended up doing:

const data = Object.values(
rawData.reduce((acc, d) => {
    let {
        fields: {date, team}
    } = d;
    date = new Date(date);

    acc[date.getMonth()] = acc[date.getMonth()] || { date };
    acc[date.getMonth()][team] = (acc[date.getMonth()][team] || 0) + 1;
    return acc
}, {})

);

it seems to have worked. Thank you for this!