Filter a project report by Days Since Entry

Forum|Forum|2 years ago
May 12, 2023
3 replies
794 views

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!

Workfront

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

Best answer by skyehansen

hi, did you try reading the documentation here?

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/use-date-based-wildcards-generalize-reports.html?lang=en

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/understand-wildcard-filter-variables.html?lang=en

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?

MoniqueEvans

New Participant

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

Kundanism

New Participant

@justinwa2

Can you try this;

skyehansenAccepted solution

New Participant

hi, did you try reading the documentation here?

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/use-date-based-wildcards-generalize-reports.html?lang=en

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/report-elements/understand-wildcard-filter-variables.html?lang=en

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?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded