Updating Time off Days to include Half days | Community
Skip to main content
N
nerdyjess
Level 2
October 4, 2022
New

Updating Time off Days to include Half days

  • October 4, 2022
  • 2 replies
  • 418 views

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 replies

    William
    Community Advisor
    WilliamCommunity Advisor
    Community Advisor
    October 4, 2022

    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

     

    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    Lyndsy-Denk
    Community Advisor
    Lyndsy-DenkCommunity Advisor
    Community Advisor
    June 8, 2023

    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.

    Terms & ConditionsAccessibility statement

    Loading footer...