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
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 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,722)