https://community.esri.com/t5/arcgis-pro-questions/update-integer-field-with-datediff/m-p/1388053#M79453 <P>I've been asked to create an Arcade script that calculates the difference between the start and end date of a project. The value should populate an integer field with hours. The start and end date fields are formatted with date and time, because we need to track to the hour how long is spent working on the project.&nbsp;</P><P>I have the below script and fields. I would like to implement this as an attribute rule going forward. Any idea how to get it to automatically populate the TimeDiff field? I'm assuming the inclusion of time is the issue, but I need to include it.&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MikhaylaB_1-1709130393846.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/96130iEA520A4236A16411/image-size/medium?v=v2&amp;px=400" role="button" title="MikhaylaB_1-1709130393846.png" alt="MikhaylaB_1-1709130393846.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MikhaylaB_0-1709130369476.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/96129i47FE179A007BB8D5/image-size/medium?v=v2&amp;px=400" role="button" title="MikhaylaB_0-1709130369476.png" alt="MikhaylaB_0-1709130369476.png" /></span></P><P>&nbsp;</P> Wed, 28 Feb 2024 14:34:08 GMT MikhaylaB 2024-02-28T14:34:08Z https://community.esri.com/t5/arcgis-pro-questions/update-integer-field-with-datediff/m-p/1388053#M79453 <P>I've been asked to create an Arcade script that calculates the difference between the start and end date of a project. The value should populate an integer field with hours. The start and end date fields are formatted with date and time, because we need to track to the hour how long is spent working on the project.&nbsp;</P><P>I have the below script and fields. I would like to implement this as an attribute rule going forward. Any idea how to get it to automatically populate the TimeDiff field? I'm assuming the inclusion of time is the issue, but I need to include it.&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MikhaylaB_1-1709130393846.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/96130iEA520A4236A16411/image-size/medium?v=v2&amp;px=400" role="button" title="MikhaylaB_1-1709130393846.png" alt="MikhaylaB_1-1709130393846.png" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MikhaylaB_0-1709130369476.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/96129i47FE179A007BB8D5/image-size/medium?v=v2&amp;px=400" role="button" title="MikhaylaB_0-1709130369476.png" alt="MikhaylaB_0-1709130369476.png" /></span></P><P>&nbsp;</P> Wed, 28 Feb 2024 14:34:08 GMT https://community.esri.com/t5/arcgis-pro-questions/update-integer-field-with-datediff/m-p/1388053#M79453 MikhaylaB 2024-02-28T14:34:08Z https://community.esri.com/t5/arcgis-pro-questions/update-integer-field-with-datediff/m-p/1388081#M79457 <P>This works:</P><P>var StartDate = $feature.TimeStart<BR />var EndDate = $feature.TimeEnd<BR />var TimeDiff = DateDiff(EndDate, StartDate, 'hours')<BR />return TimeDiff</P> Wed, 28 Feb 2024 15:08:33 GMT https://community.esri.com/t5/arcgis-pro-questions/update-integer-field-with-datediff/m-p/1388081#M79457 MikhaylaB 2024-02-28T15:08:33Z