You’re offline. This is a read only version of the page.
Announcements
188
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
Share
Report
All responses (
Answers (
