So I'm using a slider to measure progress against SLA dates. I followed this video https://youtu.be/rkENxo2_PX8 to find out how to do it but I had to adjust slightly to take business days into account and not just regular days.
I have no errors and I feel it's almost there. I think the max is fine however it's just not working correctly so I think the issue is at the "default" for the slider.
So for Max I have this
RoundDown(DateDiff(DPAssigned.SelectedDate, DPCurrentSLADate.SelectedDate, Days) / 7, 0) * 5 +Mod(5 + Weekday(DPCurrentSLADate.SelectedDate) - Weekday(DPAssigned.SelectedDate), 5)
and at Default I have this
DateToday-DPAssigned.SelectedDate
which I know is not right as it's too simplistic ! and it doesn't take business days into account. I've tried numerous combinations but no joy.
The 2 date fields that being compared are DPAssigned and DPCurrentSLADate both Date picker fields and I need the slider to show me visually where I am today based on those dates...
Any ideas?
TIA
