web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Date from Speci...

Power Apps

Unanswered

Filter Date from Specific WEEK Contains

(0) Share

Report

Report

Posted on by dyna009

35

Hello Everyone,

Please help me in this task, i need solution on this task.

I want to filter record that contains next week date and next to next week date.

I want to send report to my manager every Friday how many employee on leave on next week and next to next week.

In this case, if start date should be the current week and end date should be next week, i want contain those record also.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You can use the DateAdd() Fubction to Now() function +14 days to get you two weeks time date. Then do a filter where start date is greater than or equal to now and less than or equal to your +14 day date.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You can use the Date Add function.

1 - Find Monday of current week
DateAdd(Now(),1-Weekday(Now(),StartOfWeek.Monday),Days)

2 - Then just add 7 days
DateAdd(result.SelectedDate,7)

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Join the conversation