topic Re: Arcade expression for 6 years after effective date in ArcGIS Online Questions

Arcade expression for 6 years after effective date

L77 — Wed, 29 Jun 2022 22:45:51 GMT

I need help writing an expression to use in ArcGIS online in a hosted feature service for symbolizing forest practice application data.

This is what I need it to display:

If (The effective date plus 6 years)= date before today, Label & Symbol: "6 year moratorium has ended"

If (The effective date plus 6 years)= date after today, Label & Symbol: "Active Permit"

This is the dataset I am using:

I started out writing this, but it isn't correct.

var startDate = $feature["EFFECTIVE_DT"];
var sixyears = DateAdd(startDate,6, 'years')
return sixyears;

SteveCole — Wed, 29 Jun 2022 22:59:25 GMT

Maybe try something like this before your DateAdd line? Maybe it's not treating the date as you expect it to be..

var recordDate = Date($feature.dateField)

JohannesLindner — Thu, 30 Jun 2022 08:49:04 GMT

You're almost there. The last step is to determine whether the date you calculated is before or after today:

var startDate = $feature["EFFECTIVE_DT"]; var sixyears = DateAdd(startDate,6, 'years') return sixyears < Today()

This will return true for permits that passed the moratorium date, false for active permits.

Then you can change the legend labels:

And that's it.

L77 — Thu, 30 Jun 2022 14:12:06 GMT

Thank you so much, I really appreciate the help!