Creating a YTD report for tasks closed on weekends

[SuryaLakhani]

Hello!

I have an interesting request to capture all tasks that were closed over the weekend, specifically between Friday at 6 pm ET and Monday at 8 am ET.

I think I can find a way to do this using Fusion, but I wanted to check if anyone here had an idea for creating a report in Workfront to capture this. 

[RowvillBh1]

@SuryaLakhani If you are fine with creating calculated fields on all tasks then the below might work.

Add 2 calculated fields on a custom form and add that custom form to all the tasks. You can keep it Admin only so that no one else is able to see it.

1. Create a custom calculated field like 'Day' with the formula - DAYOFWEEK({actualCompletionDate})

2. Create a custom calculated field like 'Hour' with the formula - HOUR({actualCompletionDate})

Once the custom fields are created and the custom form is added to all the tasks then create a task report with a filters for days 5,6,7,1 and Hours as needed. Note that DAYOFWEEK will out 1 as Sunday and 7 as Saturday. This should get you what you are looking for.