Skip to main content
nerdyjess
Level 2
Oct 4, 2022 8:16 PM UTC
New

Updating Time off Days to include Half days

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
    Adobe Employee
    WilliamAdobe Employee
    Adobe Employee
    Oct 4, 2022 8:30 PM UTC

    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

     

    Translate
    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    Lyndsy-Denk
    Adobe Champion and Community Advisor
    Lyndsy-DenkAdobe Champion and Community Advisor
    Adobe Champion and Community Advisor
    Jun 8, 2023 3:56 PM UTC

    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.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...