web

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

News and Announcements icon

Power Platform CommunityForums Power Apps set value in calendar ...

Power Apps

Answered

set value in calendar excluding weekend

(0) Share

Report

Report

Posted on by Dynatech123

59

Hello Everyone,

I have requirement to display value 1 in calendar and where Saturday and Sunday then display 0 ,

I have 2 Date Picker control Datepicker1 and Datepicker2

when Select date between them then set value 1 in label as below

Now when I select date between 2 date picker then set value 1 but it also include Saturday and Sunday,

but I want to Exclude Saturday and Sunday and set value 0 at that specific Saturday/Sunday date.

this task in high priority, so please anyone help me with this.

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (2)

Sort by

Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Please add below condition where you are putting 1 or 0 in calendar
Weekday(YourDate)=1 ||Weekday(YourDate)=7 Your Formula will look like If(Weekday(YourDate)=1 ||Weekday(YourDate)=7,0,1)
Dynatech123 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @theapurva ,
Thanks for your suggestion it's Work Perfectly,
Now you have any idea how can we include last Saturday of month in your suggested code,
please can you help me with this also
Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
This formula returns true if day is last Saturday of month,
Weekday(YourDate)=7&&(DateAdd(YourDate,7,Days))=Month(YourDate)

so your formula would look as below:

If(Weekday(YourDate)=1 ||(Weekday(YourDate)=7&&(Month(DateAdd(YourDate,7,Days))=Month(YourDate))),0,1)
Dynatech123 59 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @theapurva ,
Thank you for your quick response,
your suggested code work perfectly for me

Join the conversation