Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
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.