I want 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
I tried using a calculated column but some how I cannot connect the calculated column to the column in the form in order to display/cannot display the column in the form
Thanks in advance!.
There are few ways of doing it.
You can create Form Variable and show that variable into calculated value control. please follow below steps:
Other option is , you can add Calculated Value control on the form and use above mention runtime function directly.
Here is a pretty good tutorial using date difference already written on the forums:
Is it possible to make the format like this - 0 days, 01 hrs, 00 mins when calculating the date difference and how do I go about doing that?
There are 3 different runtime function (1) dateDiffDays (2) dateDiffHours (3) dateDiffMinutes.
I am sure it will help you to achieve what you after.
Let me know how you go. Let me know if you need help in your specific scenario in this, might try to create form for you and send you.
I have attached exported list form. Please import that and see if it helps.
Let me know if any questions.
hello Shirin Patel
i dont know how it works, not sure if the problem is in my form
i imported yours and i also had the same outcome
i modified it to get the results i wanted like below