Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

Filter by Planned Completion Date Timestamp

Avatar

Level 2

Does anyone know if there is a way to filter a report based on the timestamp of the planned completion date versus a date? For example, we have users who are entering projects in Workfront but due to their timezone, the planned completion date for jobs they enter is defaulting to 1:00 AM. I want to pull a report of projects where the timestamp is 1:00 AM however, I don't think this is an option. It seems as though I can only filter by a date range. 

 

Any thoughts? 

1 Reply

Avatar

Community Advisor

the calculated data expressions page shows a calculation for “hour”, so maybe starting with using this as a calculated field and then filtering on anything you don’t want to see…?

 

https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/cal...