Calculated time between fields (combined)
Scenario:
We have a template where users can submit a request to work remotely for up to 90 days in a calendar year. The user can take all of the allotted time at once or divide it up throughout the year.
Use Case:
HR would like to better track the total time taken by an user during the year. In some cases, users submit multiple requests for remote work during the year and HR wants to ensure they/we stay within the 90 day allottment.
Requirement:
Must Have:
Calculate the number of working days between two Date fields. Display this data in a new Request field.
Date of Travel: 6/2/25
Requirement:
Must Have:
Calculate the number of working days between two Date fields. Display this data in a new Request field.
Date of Travel: 6/2/25
Date of Return: 6/13/25
Total Days : 10 days
Could Have:
Associate the Total Days taken, by year, to an user account