Expand my Community achievements bar.

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

Avatar

Level 10

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!

6 Replies

Avatar

Community Advisor

Hi Jill,

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

plannedCompletionDate=$$NOW+120D

Avatar

Level 10
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.

Avatar

Level 10
Oh wait! It did work but using $$TODAY. Somehow in all my futzing around I had changed the modifier to EQ instead of LT and didn’t notice. Sigh‚Ķ thank you!!

Avatar

Level 3

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!

Avatar

Community Advisor

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

Avatar

Employee

Hey Jill,

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

plannedCompletionDate=$$TODAY+120d plannedCompletionDate_Mod=lte