Expand my Community achievements bar.

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.