Answered

Filtering on date range

(0) Share

Report

Posted on by russrimm Microsoft Employee

Hi all,

I have a dropdown that is populating events on todays date using
Filter(EventCollect,Date(Year('Event Start Date and Time'),Month('Event Start Date and Time'),Day('Event Start Date and Time'))=Today())

Now I want it to populate events from today and for the past 7 days.

I'm trying this, but it appears to be showing all events today backward beyond the past 7 days.

Filter(EventCollect,Date(Year('Event Start Date and Time'),Month('Event Start Date and Time'),Day('Event Start Date and Time')) < DateAdd(Today(),-7,Days))

Tips?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

LRVinNC 2,297 on at

Like (1)

Report
Copy link

Link copied!

If I read your statement correctly, you are currently telling it to subtract 7 days from today to get a new date and compare then comparing Event Start Date against that new date that is 7 days prior to today. I think what you are really trying to do is get those where the date is GREATER THAN OR EQUAL to 7 days ago. (or simply greater than 8 days ago).

I would try changing your -7 to a -8 and reversing the > to a < and see what you get.

Was this reply helpful? Yes No
Verified answer

wyotim 2,545 on at

Like (2)

Report
Copy link

Link copied!
I think your inequality is the issue. You are looking for everything smaller than (i.e. earlier than) a date that is seven days before today.

You might try the following:
Filter( EventCollect, Date( Year('Event Start Date and Time'), Month('Event Start Date and Time'), Day('Event Start Date and Time') ) >= DateAdd(Today(),-7,Days) )
If there is the possiblity of dates bigger than (i.e. later than) today, you might want to add the following:
Filter( EventCollect, Date( Year('Event Start Date and Time'), Month('Event Start Date and Time'), Day('Event Start Date and Time') ) >= DateAdd(Today(),-7,Days), Date( Year('Event Start Date and Time'), Month('Event Start Date and Time'), Day('Event Start Date and Time') ) <= Today() )

Was this reply helpful? Yes No
russrimm Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you the 2nd example you gave is exactly what I needed!! Much appreciated.

Was this reply helpful? Yes No