Power Platform Community Forum Thread Details

I currently have an application where an employee can select a date from a date picker. When collecting the data, I need identify the start of the week and end of the week based on the date the employee selected. For example, if they select 12/28/23, I need to collect the previous Monday (12/25/23) and the proceeding Sunday (12/31/23).

Is there a way to dynamically grab those 2 dates based on the selected date in a date picker?

Categories:

Building Power Apps

Hi @CSilva

In PowerApps, the Weekday function can be used to find the day of the week for a date (1 for Sunday, 2 for Monday, and so on). Create a Label control to display.

// Start of the week (Monday)
DatePicker1.SelectedDate - Weekday(DatePicker1.SelectedDate, StartOfWeek.Monday) + 1

// End of the week (Sunday)
DatePicker1.SelectedDate - Weekday(DatePicker1.SelectedDate, StartOfWeek.Monday) + 7

(Or)

Use Collection:

ClearCollect(
WeekStartEnd,
{
StartOfWeek: DateAdd(DatePicker1.SelectedDate, 1 - Weekday(DatePicker1.SelectedDate, StartOfWeek.Monday), TimeUnit.Days),
EndOfWeek: DateAdd(DatePicker1.SelectedDate, 7 - Weekday(DatePicker1.SelectedDate, StartOfWeek.Monday), TimeUnit.Days)
}
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.