Workfront

JenniferMa10 · 3/26/25

Hello!

I am stumped. I need to create a wildcard filter for projects sitting 3 days after entry date. I do not want to include the entry date within my filter, but it continues to populate.

What am I doing wrong?

Thank you!

JM

Alex_Di · 3/26/25

Hi @JenniferMa10

I'm not 100% sure this is what you are asking for, but here is an example of a filter for projects in Planning status entered more than 3 days ago.

If this helps, please consider marking as correct.

Alex

View solution in original post

tibormolnar · 3/26/25

Hello JM,

have you tried the "Between" operator, instead "Equal (Case Sensitive)"?

Also, note that $$NOW is equal to the current date and time. You may want to use $$TODAY instead, something along the lines of Between $$TODAY-4d and $$TODAY-3d.

I hope this helps,

Tibor

Alex_Di · 3/26/25

Hi @JenniferMa10

I'm not 100% sure this is what you are asking for, but here is an example of a filter for projects in Planning status entered more than 3 days ago.

If this helps, please consider marking as correct.

Alex

JenniferMa10 · 3/27/25

This worked for me! Thank you @Alex_Di

Srinija_N · 3/26/25

This should be the filter that you are looking for. Hope this helps!

Please mark my response as 'Correct Reply' if this helped you and also to help others.

Thanks in advance.

JenniferMa10 · 3/26/25

This makes more sense; however, it's still picking up a project that was submitted yesterday?

I even tried $$TODAY+3d?

tibormolnar · 3/26/25

Can you be more specific about what exactly you're after? Your initial question was a little ambiguous.

Here's how I understand these wildcards:

Projects created in the past 72 hours: BETWEEN $$NOW-3d AND $$NOW
Projects created any time in the previous 3 days (but not today): BETWEEN $$TODAY-3d AND $$TODAY
Projects created on the day 3 days ago (e.g. running the report any time on Friday would give you projects created between 00:00-24:00 on Tuesday): BETWEEN $$TODAY-3d AND $$TODAY-2d

JenniferMa10 · 3/27/25

Not a problem.

I want to run a report that yields projects that have not been assigned 3 days after their entry date, so I can ping the team and understand the lag time.

I need my filter to focus on the entry date + 3 days, but I have not been able to successfully do this.