Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

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

Level 8

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.