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

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like (1)

Report
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)

Was this reply helpful? Yes No
Dynatech123 59 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like (1)

Report
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)

Was this reply helpful? Yes No
Dynatech123 59 on at

Like (1)

Report

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

Was this reply helpful? Yes No

Join the conversation