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!
Hi Jill,
at a quick glance I think you just need to remove the spaces
plannedCompletionDate=$$NOW+120D
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hey Jill,
You should have no problems using $$TODAY+120d. 120d should be fine.
plannedCompletionDate=$$TODAY+120d
plannedCompletionDate_Mod=lte
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies