nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate time between two date-times using a date formatted from a pulldata question

LeslieO_Hare2

Hi,

I would like to calculate the hours (in decimal time) between the current inspection date/time and the previous inspection date/time. I am using the pulldata function to recall the last inspection date/time and the now() function to populate the date/time of the current inspection, but when I try to calculate the time between the two dates I get an validation error message. I think (but really I'm just guessing) the pulldata function is inserting the previous date/time as a string in epoch time and I can't figure out what the calculation formula should be? Below is a copy of my form. Any help would be appreciated!!

type	name	calculation	bind::Type
dateTime	DateTime	now()
note	dateTimePrevious	'pulldata("@layer","getValue","attributes.DateTime","https://services2.arcgis.com/lIdP1KS6Ves6C693/arcgis/rest/services/service_85b98d8810d94245a64f30d3a6dc10ef/FeatureServer/0?orderByFields=DateTime DESC", ${WhereClauseFacID})	decimal
note	Duration	(decimal-date-time(${dateTimePrevious}) - decimal-date-time(${DateTime}))	decimal

Vind meer berichten getagd met

Accepted answers

abureaux

Have you tried putting the pulldata into a text field to see what format it's pulling? If you are pulling from a dateTime field and dumping that value into a dateTime field, I feel like it should work.

Regarding the time difference, I'm not sure I understand. Do you just want the number of hours between two dates? That is relatively simple:

You will want some type of rounding on this otherwise you will end up with a very small decimal due to the slight differences in time. E.g.:

All comments

abureaux

All dates and times in S123 are captures in as a Unix Time Stamp.

All calculations (e.g., determining difference between two dates/times) needs to be done in Unix Time.

Whatever is captured in a date or dateTime question will print out as a "human date" in Feature Reports automatically.

If you want to display a captured date/time somewhere else in S123 (such as the instance_name, or display the result of a calculate) you will need to use format-date() or format-time() first.

hh:mm:ss = format-time(${your_question},'%H:%M:%S')

SusanMathai

How to capture time input format hh:mm:ss. and do calculations in survey forms for example start time as hh:mm:ss and End time as hh:mm:ss. then report the time difference in minutes and seconds in a text box. I was able to display the difference in minutes as follows.

LeslieO_Hare2

Thank you, that worked! I previously changed the field type to DateTime, but I think I just had the calculation incorrect.

abureaux

Regarding the time difference, I'm not sure I understand. Do you just want the number of hours between two dates? That is relatively simple:

You will want some type of rounding on this otherwise you will end up with a very small decimal due to the slight differences in time. E.g.:

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.