cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
makhan1215
New Member

Leave Request form

Hello, I am working on leave request app but when i select leave start date and end date it does not exclude weekend from it. below are my FX. Please check

 

Onchange startdate and enddate picker:

RoundDown(DateDiff(StartDate.SelectedDate,EndDate.SelectedDate,Days)/7,0)*5+Mod(5+Weekday(EndDate.SelectedDate)-Weekday(StartDate.SelectedDate),5)

 

Label where total applied leave display when select start and end date. FX below.

FX on label Text:

DateDiff(Switch(Radio1.Selected.Value,"Half Day",DateAdd(StartDate.SelectedDate,12,Hours),StartDate.SelectedDate),Switch(Radio2.Selected.Value,"Day",DateAdd(EndDate.SelectedDate,24,Hours),EndDate.SelectedDate),Hours)/24

 

Please let me know how to exclude weekend from date selection

0 REPLIES 0

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,723)