Expand my Community achievements bar.

Submissions are now open for the 2026 Adobe Experience Maker Awards.
SOLVED

Filter Journal Entry Report on Project Start Date

Avatar

Level 1

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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.

Avatar

Level 1

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