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

Compare Current Date to Future Date to Display Data ArcGIS Online

joerodmey

Hi,

Right now I have polygon data representing ponds in a webmap. Within the polygona data I have an attribute which is the expiry date of the certification for the pond.

What I want to show is the based on the current date (must change daily) is how many months from now till the expiry date exist visually using a 3 color mode:

expiry within 1 month
expiry within 3-6 months
expiry 12 months+

How is this possible? Is an arcade an option?

Xander Bakker‌

Thanks

Find more posts tagged with

Accepted answers

XanderBakker

Hi joe rodmey ,

That is a typical case you could do using Arcade in the symbology. See the example below:

<SPAN class="keyword token">var</SPAN> expdate <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>ExpireDate <SPAN class="comment token">// change to your field</SPAN>
<SPAN class="comment token">// var expdate = Date(2021, 1, 1);</SPAN>
<SPAN class="keyword token">var</SPAN> expiremonths <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN>expdate<SPAN class="punctuation 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="string token">"months"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> result <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 1 month"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 1-3 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 3-6 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">12</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 6-12 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"12 months+"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> result<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

XanderBakker

Hi joe rodmey ,

That is a typical case you could do using Arcade in the symbology. See the example below:

<SPAN class="keyword token">var</SPAN> expdate <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>ExpireDate <SPAN class="comment token">// change to your field</SPAN>
<SPAN class="comment token">// var expdate = Date(2021, 1, 1);</SPAN>
<SPAN class="keyword token">var</SPAN> expiremonths <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN>expdate<SPAN class="punctuation 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="string token">"months"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> result <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 1 month"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 1-3 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 3-6 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">12</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 6-12 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"12 months+"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> result<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

joerodmey

Thanks Xander Bakker!

Just 2 questions. Wouldn't there be a stop limit? By this I mean should there a limit to the say the "within 1-3 months" category that not only has ❤️ but a condition to not capture anything less than 1 month or the else if handles that?

Also how does DateDiff() do its comparison? When it looks at months is it looking at the particular dates that are passed in (For example May 8 expiry with April 8 current date) or is it just comparing month of April with month of May and saying that's 1 month difference regardless of the exact day in the month?

I would also like to only have the expiry within 1-3 months and not expiry less than 1 month. For that category I only need to see everything that is expiring from today to 3 months out.

XanderBakker

Hi joe rodmey ,

Let me answer your questions below:

Wouldn't there be a stop limit? By this I mean should there a limit to the say the "within 1-3 months" category that not only has ❤️ but a condition to not capture anything less than 1 month or the else if handles that?

The validation starts with the first condition and if the value is less than 1, it will stop at the first condition. In case it does not match the condition it starts with the second. This way the classification is done correctly.

Also how does DateDiff() do its comparison? When it looks at months is it looking at the particular dates that are passed in (For example May 8 expiry with April 8 current date) or is it just comparing month of April with month of May and saying that's 1 month difference regardless of the exact day in the month?

Have a look at the expression below:

<SPAN class="keyword token">var</SPAN> expdate <SPAN class="operator token">=</SPAN> <SPAN class="token function">Date</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">2020</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">10</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">var</SPAN> expiremonths <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN>expdate<SPAN class="punctuation 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="string token">"months"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">return</SPAN> expiremonths<SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Note that the month "4" is a value from 0 to 11, so 4 represents May in this case. The result is a decimal value: 1.064516129032258. So, it takes to dates and returns the difference in decimal months in this case.

I would also like to only have the expiry within 1-3 months and not expiry less than 1 month. For that category I only need to see everything that is expiring from today to 3 months out.

In that case you can remove the first condition:

<SPAN class="keyword token">var</SPAN> expdate <SPAN class="operator token">=</SPAN> $feature<SPAN class="punctuation token">.</SPAN>ExpireDate <SPAN class="comment token">// change to your field</SPAN>
<SPAN class="keyword token">var</SPAN> expiremonths <SPAN class="operator token">=</SPAN> <SPAN class="token function">DateDiff</SPAN><SPAN class="punctuation token">(</SPAN>expdate<SPAN class="punctuation 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="string token">"months"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="keyword token">var</SPAN> result <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 3 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 3-6 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>expiremonths <SPAN class="operator token"><</SPAN> <SPAN class="number token">12</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"within 6-12 months"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">{</SPAN>
    result <SPAN class="operator token">=</SPAN> <SPAN class="string token">"12 months+"</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN>

<SPAN class="keyword token">return</SPAN> result<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

joerodmey

Thanks

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.