Report on Projects due <= $$NOW + 120D | Community
Skip to main content
J
JillAc
Level 10
May 14, 2020
Question

Report on Projects due <= $$NOW + 120D

  • May 14, 2020
  • 4 replies
  • 1028 views

I'm trying to get a report to return projects with a Planned Due Date that are less than 120 days from now (ie including things that are overdue). Any help is appreciated. Less than or equal to Now plus 120 days makes logical sense to me, but I'm sure that syntax is wrong and I can't find how to write this.

This is my filter:

portfolioID=59433d40000782271a106a669f44ac02

portfolioID_Mod=notin

statusEquatesWith=CUR PLN

statusEquatesWith_Mod=in

queueDef:isPublic=0

queueDef:isPublic_Mod=in

plannedCompletionDate=$$NOW + 120D

plannedCompletionDate_Mod=lt

Thanks!

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

    4 replies

    Heather_Kulbacki
    Community Advisor
    Heather_KulbackiCommunity Advisor
    Community Advisor
    May 15, 2020

    Hi Jill,

    at a quick glance I think you just need to remove the spaces

    plannedCompletionDate=$$NOW+120D

    J
    JillAcAuthor
    Level 10
    May 15, 2020
    Hi Heather Thanks for this but it didn’t work. Report is blank. When I change it to $$TODAY + 120D I get one project in the report that is due today so it’s not recognizing the +120D. I think also it might have to do with the modifier LT but I’ve tried GT, EQ and nothing works to get the span of projects that I want included in the report.
    D
    DaleWh1
    Level 3
    May 15, 2020

    Hi Jill,

    So I am going to walk through your filter to make sure I understand it.

    You are looking for a project that is not in the portfolio with ID=59.....

    Projects that have a status that equates with current or planning (not pending approval)

    Projects that have a queue that is not public

    Projects that have a planned completion date that is less than 120D from now.

    A couple of questions: for planned completion date, have you tried the $$TODAY wildcard? I have seen cases where $$NOW does not seem to provide the right behavior. Also, your text above the filter says "less than or equal to", yet your filter is just less than. Should that be lte? Also, have you tried a lowercase d on 120d?

    Let me know how this works out!

    Heather_Kulbacki
    Community Advisor
    Heather_KulbackiCommunity Advisor
    Community Advisor
    May 15, 2020

    I was going to suggest the lower case d as well, since that's how it's shown here

    https://one.workfront.com/s/article/Wildcard-Filter-Variables-810113772

    but I also went back to a report that I just created earlier this week that is working and I used D there.

    Mine also uses lte since I wanted less than or equal to

    plannedCompletionDate=$$TODAY+7D

    plannedCompletionDate_Mod=lte

    one other thought I had was the number of days, is it too much for the system? Could you use 4m instead, the link above gives m for month

    D
    Adobe Employee
    DustinMaAdobe Employee
    Adobe Employee
    May 15, 2020

    Hey Jill,

    You should have no problems using $$TODAY+120d. 120d should be fine.

    plannedCompletionDate=$$TODAY+120d plannedCompletionDate_Mod=lte

    Terms & ConditionsAccessibility statement

    Loading footer...