Hi I have a form with two dateTime fields, namely ${fire_start} and ${fire_end}.
I want to be able to have in a new text type field of 8 characters, namely ${fire_duration}, in the form of xy:xy:xy which will calculate the duration of the fire event. A valid result for example would be 12 days 3 hours and 43 minutes displayed as 12:03:43, so that the first 2 characters that represent days can have values from 0 to 99, the next two representing the hours from 0 to 24, and the final two that represent minutes 0 to 60. I dont know if a leading zero for each days, hours, minutes makes it more difficult or not, but I managed with the aid of AI to make it work in the field app. The same entry with the webapp though always returns 00:00:00.
I fonund the following post but had no solution also: https://community.esri.com/t5/arcgis-survey123-questions/survey123-connect-calculation-not-translating-to/m-p/1625726
I have attached the form for anyone that can point to a solution.
Thanks in advance.
