Skip to main content
NuriaMunguia
Adobe Champion
NuriaMunguiaAdobe Champion
Adobe Champion
May 25, 2021
Question

Filter - Count business days using text mode?

  • May 25, 2021
  • 1 reply
  • 552 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

imgrund
Adobe Employee
imgrundAdobe Employee
Adobe Employee
May 25, 2021

I usually use 1 week for 5 business days (since usually they are the same. only exception is of course when you have holidays)

Also, I tend to just use the Last Update Date as that looks at both updates/notes on the task, but also status changes or assignments changes.

    Terms & ConditionsAccessibility statement

    Loading footer...