Arcade custom expression in AGOL

LeeButler84

Hi all,

I'm trying to use Arcade for this first time on a hosted feature layer in AGOL.

The data for this layer is collected by a field crew using Collector for ArcGIS.  The last_edit_date field is automatically populated for each feature during data collection.

In AGOL i want to display any features where the last edit date has exceeded a year from the current date to show that an inspection is now due on that feature.

As I've said, I'm new to Arcade but tried this expression but it doesn't seem to work correctly:

var inspDate = $feature["last_edited_date"];

if (DateAdd(inspDate, 1, year) < Today()) {
    return 'Inspection overdue';
}
else {
    return 'OK';
}

Any pointers on where I am going wrong or even if it is possible to do what I am trying to do?

Thanks

kenbuja

When using any of the Date functions, the units must be in quotes. Otherwise, it's interpreted as a variable. Try this

<SPAN class="keyword token">var</SPAN> inspDate <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"last_edited_date"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
 <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token function">DateAdd</SPAN><SPAN class="punctuation token">(</SPAN>inspDate<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"year"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><</SPAN> <SPAN class="token function">Today</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'Inspection overdue'</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">'OK'</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>
‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>