Calculate the difference between two date fields in a pop-up using Arcade in Portal for ArcGIS Map Viewer

Summary

ArcGIS Arcade is an expression language that can be used to configure pop-ups in Portal for ArcGIS Map Viewer. The Arcade Date functions provide methods for creating date objects and acquiring various properties of the objects. For example, the DateAdd() and DateDiff() functions are used to adjust the date based on a specified interval, and the Now() function is used to obtain the current local time of the client.

This article provides the steps to calculate the difference between two date fields in the pop-up in Portal for ArcGIS Map Viewer. In this example, the displayed number of days before the last fire hydrant inspection in the pop-up is obtained by referencing the field values in the Date Inspected field (as seen in the image below) and the current local time of the client.

Procedure

1. Open the map in Portal for ArcGIS Map Viewer. Click Layers on the Contents (dark) toolbar, and select the layer with the pop-up for editing. In this example, the Hydrant Painting for Collector layer is selected.

2. Click Pop-ups on the Settings (light) toolbar and click Options > Attribute expressions.

3. Click + Add expression to open the Arcade expression editor window.
4. In the editor window, specify a name for the new expression as required.
5. In the Expression dialog box, insert the Arcade expression below.

1. Define the dates to be referenced.

var <variableName> = Now()
var <variableName1> = $feature.<date_fieldName>;

2. Calculate the date difference in years.

var <variableName2> = Floor(DateDiff(<variableName>, <variableName1>, 'years'));

3. Create a new date by adding the years to the start date.

var <variableName3> = DateAdd(<variableName1>, <variableName2>, 'years');

4. Calculate the number of days between those dates.

var <variableName4> = DateDiff(<variableName>, <variableName3>, 'days');

5. Define the constraints for the field values to be displayed in the pop-up.

if (IsEmpty($feature.<date_fieldName>)){
    return "<textValue>";
} else if (<variableName2> >= <numberValue>) {
    return "<textValue1> " + <variableName2> + " <textValue2> " + Floor(<variableName4> , <numberValue1>) + " <textValue3>";
} else if (<variableName2> == <numberValue2>) {
    return "<textValue4> " + Floor(<variableName4> , <numberValue1>) + " <textValue3>";
} else if (<variableName2> == <numberValue1> && <variableName4> >= <numberValue>) {
    return "<textValue1> " + Floor(<variableName4> , <numberValue1>) + " <textValue3>";
} else if (<variableName2> == <numberValue1> && <variableName4> >= <numberValue2>) {
    return "<textValue1> " + Floor(<variableName4> , <numberValue1>) + " <textValue5>";
} else if (<variableName2> == <numberValue1> && <variableName4> < <numberValue2>) {
    return "<textValue6>";
}

The following code block demonstrates the full working Arcade script.

var timeNow = Now();
var survey = $feature.DATEINSPECTED;
var y = Floor(DateDiff(timeNow, survey, 'years'));
var date1a = DateAdd(survey, y, 'years');
var d = DateDiff(timeNow, date1a, 'days');

if (IsEmpty($feature.DATEINSPECTED)){
    return "-";
} else if (y >= 2) {
    return "Last Inspection: " + y + " years and " + Floor(d , 0) + " days ago.";
} else if (y == 1) {
    return "Last Inspection: 1 year and " + Floor(d , 0) + " days ago.";
} else if (y == 0 && d >= 2) {
    return "Last Inspection: " + Floor(d , 0) + " days ago.";
} else if (y == 0 && d >= 1) {
    return "Last Inspection: " + Floor(d , 0) + " day ago.";
} else if (y == 0 && d < 1) {
    return "Last Inspection: today.";
}

6. Click Test to view a preview of the expression result. If the required result is achieved, click OK.

7. Click the Previous button above the newly created Arcade expression in the Attribute expressions pane.

8. Click Fields list to expand the list of fields displayed in the pop-ups and click Select fields.
9. Check the expression field under the Expressions section and click Done.

The image below shows the newly added Last Inspection (days) field in the pop-up using ArcGIS Arcade to provide a count of the days or years since a hydrant was last inspected.