topic Re: Indicator Arcade Expression in ArcGIS Dashboards Questions

Indicator Arcade Expression

GaryMorris — Wed, 24 Sep 2025 18:34:10 GMT

I am creating a dashboard using a feature service. I have to text fields that have dates in dd/mm/yyyy format. I am trying to write an expression to convert the text field to a date filed and then find the amount of days between the two dates.

Any help is greatly appreciated.

Re: Indicator Arcade Expression

EmilyGeo — Wed, 24 Sep 2025 18:58:49 GMT

hi @GaryMorris,

This support article should help you with the conversion from string field to date. Then you can use DateDiff to calculate the number of days between the 2 dates.

Re: Indicator Arcade Expression

KenBuja — Wed, 24 Sep 2025 20:09:13 GMT

Here's one way to calculate the difference (this shows the number of days since the beginning of the year). Note that the month number in the Date function is 0-based (0 is January)

If your goal is to put this number into an indicator, then you have to return a FeatureSet containing that number

Re: Indicator Arcade Expression

GaryMorris — Tue, 30 Sep 2025 12:23:10 GMT

Here is what I tried so far for the conversion:

var portal = Portal('https://arcgis.com');var fs = FeatureSetByPortalItem(portal,

'ItemID', 0,['*'], false);

for (var f in fs){

var date_Applied = f["Applied_Date"];

var date_Issued = f["Issued_Date"];

var convertedDate = Date(date_Applied)

var convertedDate1 = Date(date_Issued);

}

return convertedDate1

I am getting a null value.