Task Report Actual Completion date VS Planned Completion Date

[IanBe3]

Hello,

I'm trying to build a basic task report that will pull all tasks that were completed after the planned completion date. Essentially actualCompletionDate > plannedCompletionDate. However, I want to exclude the time from the calculation. I tried playing with the CLEARTIME, but I was unsuccessful. Any help would be appreciated!

Thanks

[skyehansen]

we had a similar need a while back and if I recall correctly, you can't really do this in a report filter. We ended up making a calculated field that would just ping "late" based on our specific needs at the time, and then ran reports on everything that was "late".

(our needs at the time was we only wanted to look at stuff that was more than 2 days late, so the calculated field was basically actual > planned+2... might have had a cleartime in there as well)

[butterworthco]

This article helped me build a similar task report. https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/fil...

1. Go to a list of tasks.

2. From the Filter drop-down menu, select New Filter.

3. Click Add Filter Rule and add Actual Completion Date >Greater Than  > Select a date.

   TIP

   Choose the filter modifier you want to use for the selected field, if available.

4. Click Switch to Text Mode.

5. In the Set Filter Rules for your Report area, add the following code:

   actualCompletionDate=FIELD:plannedCompletionDate<br>actualCompletionDate_Mod=gt

   Copy

   Toggle Text Wrapping

6. Click Done, then Save Filter.

[IanBe3]

If I could just cleartime from the below I'd be in business!

actualCompletionDate=FIELD:plannedCompletionDate
actualCompletionDate_Mod=gt