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; } } }

Symbology: Arcade Expression for Date Range not working

deleted-user-jxpbpbjlZInj

So I want to symbolize a polygon layer with two different symbols: one is red if it hasn't been surveyed in the last 30 days. The other is gray if it has been surveyed in the last 30 days. This is the expression I wrote, but the symbology is homogeneously red! No difference, despite differences in values in my fields:

var rightnow = now()
var lastedit = $feature.LastSurveyDate
var difference = (rightnow - lastedit)

If (difference >30) {
return "This has not been surveyed in past 30 days"
}
else {
return "This has been surveyed in past 30 days"
}

HALP!

Find more posts tagged with

Accepted answers

XanderBakker

Please be aware that "difference" is an existing function, which might be causing the problem. Could you try with a different variable name, like "days" for example?

<SPAN class="keyword token">var</SPAN> days <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">Now</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> $feature<SPAN class="punctuation token">.</SPAN>LastSurveyDate<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"days"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>days <SPAN class="operator token">></SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"This has not been surveyed in past 30 days"</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">"This has been surveyed in past 30 days"</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>

All comments

kenbuja

Try this expression

<SPAN class="keyword token">var</SPAN> rightnow <SPAN class="operator token">=</SPAN> <SPAN class="token function">now</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> lastedit <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>LastSurveyDate<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> difference <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN>rightnow<SPAN class="punctuation token">,</SPAN> lastedit<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'days'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

If <SPAN class="punctuation token">(</SPAN>difference <SPAN class="operator token">></SPAN> <SPAN class="number token">30</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
  <SPAN class="keyword token">return</SPAN> <SPAN class="string token">"This has not been surveyed in past 30 days"</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">"This has been surveyed in past 30 days"</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>‍</SPAN><SPAN>‍</SPAN></SPAN>

That can also be simplified to

var difference = DateDiff(now(), $feature.LastSurveyDate, 'days');

If (difference > 30) {
  return "This has not been surveyed in past 30 days";
}
else {
  return "This has been surveyed in past 30 days";
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

deleted-user-jxpbpbjlZInj

Nope. Doesn't make a difference. Still a homogeneous red.

kenbuja

Can you share a snippet of your data?

deleted-user-jxpbpbjlZInj

Below there are two dates filled in for last survey date (a date field that I added after the feature service was published to AGOL as a hosted FS.) These two survey dates are attributes in two of the red grids above it.

Here's the expression:

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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