Has anyone tried to count business days within a filter? I want to see open tasks that haven't been updated in more than 5 days. System only allows for regular days, text mode for it below.
However I want to count business days.. if i could do an "Exists" combined with an IF statement and weekdaydiff between $$TODAY and lastNote:entryDate > 5.. could that work? Text Mode gurus!!! help!
DE:USCA CC Intake Status=Closed Rejected Won't Resolve
DE:USCA CC Intake Status_Mod=notin
projectID_Mod=in
lastNote:entryDate=$$TODAYb-5d
lastNote:entryDate_Mod=lt
OR:1:DE:USCA CC Intake Status=Closed Rejected Won't Resolve
OR:1:DE:USCA CC Intake Status_Mod=notin
OR:1:lastNote:noteText_Mod=isblank
OR:1:projectID_Mod=in