Arg: Is it possible to Filter for the next 3, 4, or 5 BUSINESS Days?

Thanks Skye, Interesting angle, but (yes) somewhat unrelated. For what I'm attempting to do -- find Tasks whose Planned Completion Date is between $$TODAY and +3 Business Days from now -- the concept of Lag is not a factor: only the Planned Completion Date falling within that range is of interest, whether it was ASAP, FIXT, SNET, etc...or Lagged, via "C" or "D". From the definitive (nearly; they don't mention the additive nature) works on "https://support.workfront.com/hc/en-us/articles/216742128-Understanding-Lag-Types">$$TODAY constants , "d" is the only option when it comes to Filters...and to your point, behaves like "c" (Calendar Days), when what I am after is "d" (Business Days). Q: Magic Eight Ball, do I sense an Idea Share post coming in my future? A: Reply hazy try again Regards, Doug Date-Based Variables Workfront provides two date-based wildcard options: $$TODAY This option can be used in combination with any date filter attribute. For example, if you want to display all tasks due before today, you could use the following expression: Planned Start Date < $$TODAY. This is preferable to defining a filter with today's date so you won't have to modify the filter again tomorrow, next week, or next month. $$TODAY is always equal to midnight for the current day. $$NOW This option can be used in combination with any other date filter attribute. For example, if you want to display all hour entries provided up to the current time, you can do this by using the following expression: Planned Start Date < $$NOW. This is preferred over defining a filter and using the current date and time. In other words, each time the filter runs, you will not have to modify it. $$NOW is equal the current date and time. Date wildcards can be combined with the attribute 'q', 'h', 'd', 'w', 'm', 'y' for calendar quarter, hour, day, week, month, year respectively. The qualifiers 'b' and 'e' stand for 'beginning' and 'ending' respectively. The operators '+' and '-' are used to add or subtract values from the wildcard value. Example: The wildcard, '$$TODAYb+2w' is the same as saying, 'Two weeks from the beginning of this week'. The wildcard '$$NOW+2h' is the same as saying 'two hours from now'. Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

I don't know, Doug....this is what my Magic 8 Ball says.... Just yesterday, Justin and I were looking into a similar type of filter option for something that we are working on, so it's very interesting that you would be pondering the same thing and then post this on the Community. :) The idea exchange is your destiny! Or as Yoda would say, "Your destiny, it is"! Admin Kelly-Wehrmann SSFCU

Hi Kelly, As (I'm told) confession is good for the soul... With all due respect to your Magic Eight Ball, I did indeed throw in the towel and solved it by cheating with some code: the Hot Sheet Magic Report I was working on now shows +3, +4, or +5 business days, as the end users desired, and appreciate. Regards, Doug Doug Den Hoed - AtAppStore SEE you at LEAP using the GPS App! https://tinyurl.com/LEAPGPS Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads