Using a slider as progress bar with dates

[vffdd]

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

[v-siky-msft · Accepted solution]

Hi @vffdd ,

The Default property (the day difference between today and the first day) should also take business days into account.

Please modify the Default property as follows.

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

 Sik

[vffdd]

Thanks Sik, I actually had that originally and didn't think it was what I wanted, but on closer checking it actually is !  I probably just needed external confirmation !! 🙂