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


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


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…?