Wildcard Filter for Projects sitting for 3 days after Entry Date | Community
Skip to main content
J
JenniferMa10
Level 3
March 26, 2025
Solved

Wildcard Filter for Projects sitting for 3 days after Entry Date

  • March 26, 2025
  • 3 replies
  • 770 views

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

Best answer by Alex_Di

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

3 replies

tibormolnar
tibormolnar
Level 4
March 26, 2025

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
    Alex_DiAccepted solution
    Level 3
    March 26, 2025

    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

      J
      JenniferMa10Author
      Level 3
      March 27, 2025

      This worked for me! Thank you @alex_di 

        Srinija_N
        Srinija_N
        Level 7
        March 26, 2025

        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.

          J
          JenniferMa10Author
          Level 3
          March 26, 2025

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

           

          I even tried $$TODAY+3d?

           

           

          tibormolnar
          tibormolnar
          Level 4
          March 26, 2025

          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
          Terms & ConditionsAccessibility statement

          Loading footer...