Filter A Collection With AND Condition

Input collection: myTrucks40

Year	Make	Model
2020	Ford	F150
2018	Chevy	Silverado
2019	Ford	F150
2020	Chevy	Avalanche
2017	Chevy	Silverado
2016	GM	Yukon

Output collection: mySolution40 (filter on greater than or equal to year ‘2018’ AND less than or equal to year ‘2020’)

Year	Make	Model
2020	Ford	F150
2018	Chevy	Silverado
2019	Ford	F150
2020	Chevy	Avalanche

Solution code:

//Create a collection
ClearCollect(myTrucks40,
{Year: 2020, Make: "Ford", Model: "F150"},
{Year: 2018, Make: "Chevy", Model: "Silverado" },
{Year: 2019, Make: "Ford", Model: "F150" },
{Year: 2020, Make: "Chevy",Model: "Avalanche"},
{Year: 2017, Make: "Chevy", Model: "Silverado"},
{Year: 2016, Make: "GM", Model: "Yukon"}
);

//Filter collection code
ClearCollect(
    mySolution40,
    Filter(myTrucks40,Year>=2018,Year<=2020)
);