I am trying to display the count of items that were created last month lets say now August 2022.
here is my code
With(
{
StartDate: Date(
Year(Today()),
Month(Today()) - 1,
1
),
EndDate: Date(
Year(Today()),
Month(Today()),
1
) - 1
},
ClearCollect(
collcreatedlastmonth,
Filter(
'mylist',
Created >= StartDate,
Created <= EndDate
)
)
);
I do have items created in August but it displays 0 . what is wrong with the formulae

Report
All responses (
Answers (