Filter Journal Entry Report on Project Start Date | Community
Skip to main content
A
AndreaKr1
New Member
January 17, 2025
Solved

Filter Journal Entry Report on Project Start Date

  • January 17, 2025
  • 1 reply
  • 386 views

Dear community, 


I am running several journal entry reports showing task plannedCompletionDate changes for various projects in a certain time frame. Is there a way to filter the report for entries happening only after the project actualStartDate? I am only interested in date changes after the project was set into progress and would like to exclude all changes that happened while the project was still in planning.

I was unsuccessful with text mode and I am unsure if this is possible at all. 

 

Many thanks!

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 Richard_Le_

Hi,

 

Try using the following text mode filter on a Journal Entry Report:

 

entryDate=FIELD:project:actualStartDate
entryDate_Mod=gt

 

This text mode should filter to any Journal Entries where the entry date is greater than the Project actual start date.

 

Best Regards,

Rich.

1 reply

R
Community Advisor
Richard_Le_Community AdvisorAccepted solution
Community Advisor
January 17, 2025

Hi,

 

Try using the following text mode filter on a Journal Entry Report:

 

entryDate=FIELD:project:actualStartDate
entryDate_Mod=gt

 

This text mode should filter to any Journal Entries where the entry date is greater than the Project actual start date.

 

Best Regards,

Rich.

    A
    AndreaKr1Author
    New Member
    January 17, 2025

    Thank you so much Richard, I was missing FIELD: in my text mode line. Now it works, appreciate your help.

    Terms & ConditionsAccessibility statement

    Loading footer...