Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Filter a project report by Days Since Entry

Avatar

Level 5

Need help with filtering a report. I have a project report that shows me the days since entry and I'm trying to filter it to show me only projects that are < 60 days from entry, but I can't figure it out. 

Any feedback is appreciated!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

hi, did you try reading the documentation here?

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/use-date-b...

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/understand...

 

it felt like just doing "project / entry date / between / $$TODAY / $$TODAY-60d" should have worked. Am I misreading your question or perhaps you got an error we can help troubleshoot?

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

hi, did you try reading the documentation here?

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/use-date-b...

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/understand...

 

it felt like just doing "project / entry date / between / $$TODAY / $$TODAY-60d" should have worked. Am I misreading your question or perhaps you got an error we can help troubleshoot?

Avatar

Level 10

@JustinWa2 

Can you try this;

Kundanism_1-1684222775515.png

 

 

Avatar

Community Advisor

I agree with @Kundanism and @skyehansen. The other way you could write the filter is "project > entry date: Greater Than or Equal To: $$TODAY-60d" instead of a between statement