Expand my Community achievements bar.

SOLVED

Filter a project report by Days Since Entry

Avatar

Level 4

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

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