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.

Updating Time off Days to include Half days

Avatar

Level 2

10/4/22

Description - When running a Time off Report to allow half days with days.

Why is this feature important to you - So users have the ability to see half days taken instead of just a 0

How would you like the feature to work - a column specifically for weekdatediff that is an option in the API explorer 

Current Behaviour - using text mode to populate just days with weekdatediff. 

2 Comments

Avatar

Community Advisor

10/4/22

This column in your Time Off report will show the duration of time in Hours if less than 8 hours, or in Days if more than 8 hours: 

displayname=Duration
textmode=true
valueexpression=IF((DATEDIFF({startDate},{endDate})*-1)<.3333,CONCAT((DATEDIFF({startDate},{endDate})*-1*24)," Hours"),CONCAT(ROUND((DATEDIFF({startDate},{endDate})*-1),0)," Days"))
valueformat=HTML

 

Avatar

Community Advisor

6/8/23

Thank you @William-- ! This is a great patch in the meantime.

Ultimately it would be amazing to see a simplified reporting approach to counting time off.