web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Displaying items that ...

Power Apps

Answered

Displaying items that were created last month in powerapps

(0) Share

Report

Report

Posted on by KDAI

172

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@KDAI

Please consider changing your Formula to the following:

With( {StartDate: Date(Year(Today()), Month(Today()) - 1, 1), EndDate: DateAdd(Date(Year(Today()), Month(Today()) + 1, 1), -1, Days) }, ClearCollect(collcreatedlastmonth, Filter('mylist', Created >= StartDate, Created <= EndDate ) ) );

This would include the prior month and any records in the current month.

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation