cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pword
Helper IV
Helper IV

Start Date Error

When i Submit a leave request and go to start date click the next dat, my number of days was go to 6 days heres my code. Attached my screenshot

 

Default property

 

RoundDown(
DateDiff(
StartDates.SelectedDate,
EndDates.SelectedDate,
Days
) / 7,
0
) * 6 + Mod(
6 + Weekday(EndDates.SelectedDate) - Weekday(StartDates.SelectedDate),
6

) + If(Checkbox3.Value = false , 0.5)

- CountRows(
Filter(
colHolidays,
HolidayDates >= StartDates.SelectedDate,
HolidayDates <= EndDates.SelectedDate
)
)+1 /2

0 REPLIES 0

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,842)