Report for active projects where planned completion date is greater than 6 months | Community
Skip to main content
Laura-MC
Laura-MC
New Participant
April 28, 2023
Solved

Report for active projects where planned completion date is greater than 6 months

  • April 28, 2023
  • 2 replies
  • 818 views

Can someone assist with what the the reporting filters/text mode (or calculated field if needed) would be to create a report of all active projects in which the planned completion date is greater than 6 months? 

 

Thanks in advance! 
Laura

    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 Madalyn_Destafney

    Aha. This may be more helpful as a FILTER in your Projects page instead of a report...
    If you have your settings as the start date = the day you're creating the project, you could have the filter be project due on (planned completion date) is less than TODAY+6months

    Thoughts?

     

    2 replies

    Laura-MC
    Laura-MCAuthor
    New Participant
    April 28, 2023

    Thank you Madalyn. 

     

    However, what I am looking for is a filter that can be applied to all of our active projects. So the report will show all active projects in which the planned completion date is 6 months greater than the actual start date of the project. 

    Madalyn_Destafney
    Madalyn_DestafneyAccepted solution
    New Participant
    April 28, 2023

    Aha. This may be more helpful as a FILTER in your Projects page instead of a report...
    If you have your settings as the start date = the day you're creating the project, you could have the filter be project due on (planned completion date) is less than TODAY+6months

    Thoughts?

     

    If this helped you, please mark correct to help others : )
      Madalyn_Destafney
      Madalyn_Destafney
      New Participant
      April 28, 2023

      You're in luck, this is very simple! Include whatever date appropriate, this is example:

      If you found this helpful, please mark correct to help others : )

       

      If this helped you, please mark correct to help others : )
      Terms & ConditionsAccessibility statement

      Loading footer...