Topic
To calculate the difference between two date/time using calculated value in the form, so that users can be able to see the difference when the view item.
Instructions
Create Form Variable and show that variable into calculated value control. please follow below steps:
- Create Form Variable
- Click on Form Variable button
- Click on formula, it should give you Formula Builder
- Select Runtime Functions
- Select either dateDiffDays, dateDiffHours or dateDiffMinutes, it depends on which formate you want
- Put your both date values
- Click Ok
- Add Calculated Value control on the form and add newly created variable into formula
- Publish form and it should work
