Unanswered

Solution: Find out Monday's Date

(2) Share

Report

Posted on by Brian Dang

3,976

Problem: you want to Filter a Gallery based on data in the current week. You set up two DatePickers to set the start (DatePicker1) and end dates (DatePicker2). However, you want the DefaultDate of DatePicker1 to be the Monday of the current week.

I have a solution for calculating the Monday. Set DatePicker1.DefaultDate to:

DateAdd(Today(),
	If(Weekday(Today())=1,-6,
		Weekday(Today())=2,0,
		Weekday(Today())=3,-1,
		Weekday(Today())=4,-2,
		Weekday(Today())=5,-3,
		Weekday(Today())=6,-4,
		Weekday(Today())=7,-5
	)
)

This formula subtracts the number of days relative to the last Monday and outputs a date.

If you prefer a Sunday, you just need to change the number to subtract, or you could shift the Weekday formula to another mode.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

rgruian on at

Like (6)

Report

Try this, it may be simpler:

Today() + 7 - Weekday(Today(), MondayZero)

I hope this helps.

Was this reply helpful? Yes No
opticshrew2 117 on at

Like (2)

Report
I tried the following, seems to work aswell 😄

Start of Week

DateAdd(Today(), -1 * (Weekday(Today(), Monday) - 1), Days)

End of Week
DateAdd(Today(), 7 - Weekday(Today(), Monday), Days)

Was this reply helpful? Yes No
Digital 1,207 on at

Like (0)

Report
I would like to do something similar.

I would like the date to default to the Monday of the current working week when the user selects a date. For example if they selected the Wednesday of a particular week, a variable would be set containing the date of the Monday for that week.

This is for a time sheet app where the user is using the calendar to select the working week rather than a particular day. In most cases users will select the Monday but I want insurance against selecting other dates as this messes up the presentation of the app.

I have a gallery of days of the week labels that uses the following sequence to generate the week. If gblWeekStart is not set to Monday it messes things up.

ForAll(Sequence(7), gblWeekStart + Value - 1)

Was this reply helpful? Yes No
Joel CustomerEffective 3,224 on at

Like (3)

Report
@Digital here is an easier way
Datepicker1.SelectedDate-WEEKDAY(DatePicker1.SelectedDate,2)+1

This will give you the Monday of any date you feed it

Was this reply helpful? Yes No
Digital 1,207 on at

Like (0)

Report

@jlindstrom , Perfect. Thank you!

Was this reply helpful? Yes No
opticshrew2 117 on at

Like (1)

Report

I love it how in this thread alone we've listed three methods to retrieve the same value 😄

Was this reply helpful? Yes No
jaxkookie 18 on at

Like (0)

Report

@opticshrew2
can you explain the start of week formula? why do we multiple by -1 and then subtract 1?
thanks

Was this reply helpful? Yes No