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

Arcade expression for date ranges

karyal@stalbert.ca_stalbert

can some one help me correct the expression for the maintenance done in different date ranges

example:

var daterange = date(2020,1)<(2020,7)
var daterange1 = date(2020,8)<(2020,12)
var maint =DomainName($feature,"MAINTENANCE_TYPE") (it has 3 domains as regular, non-scheduled, and emergency)

if (maint=daterange) {
return "Spring-Summer";
if (maint=daterange1){
return "Fall-Winter";
} else {
return "Other"
}

Vind meer berichten getagd met

Accepted answers

XanderBakker

Hi @KhemAryal and @JoshuaBixby ,

See the example below:

// change the name of the field
var datemonth = Month($feature["Name of the Date Field"]); 
var maint = Proper(DomainName($feature,"MAINTENANCE_TYPE"), "firstword");

if (datemonth < 7) {
    return maint + " Spring";
} else {
    return maint + " Fall";
}

Note that the month value is a value from 0 to 11 and not 1 to 12. So spring (including July) should be a value < 7.

All comments

XanderBakker

Hi @KhemAryal and @JoshuaBixby ,

See the example below:

// change the name of the field
var datemonth = Month($feature["Name of the Date Field"]); 
var maint = Proper(DomainName($feature,"MAINTENANCE_TYPE"), "firstword");

if (datemonth < 7) {
    return maint + " Spring";
} else {
    return maint + " Fall";
}

Note that the month value is a value from 0 to 11 and not 1 to 12. So spring (including July) should be a value < 7.

bixb0012

The following structure should work:

IIf(Month(maint_date) < 8, "spring", "fall")

karyal@stalbert.ca_stalbert

Hi, thanks for the information,

I am very new to arcade and trying to learn stuff here. In my example, I have Date field and Maintenance Field (with three domains regular, non-schedule, emergency)

I am trying to show in symbol with arcade expression

emergency maintenance done between

January to July as Emergency Spring

August to December as Emergency "fall"

regular maintenance done between

January to July as Regular Spring

August to December as Regular "fall"

non-schedule maintenance done between

January to July as non-schedule Spring

August to December as non-schedule "fall"

bixb0012

There are several things to comment on, but I don't have time to hit on them all now, so I will touch on the biggest.

First, you are making bad Date function calls. You have to specify a day as well, i.e., Date(2020,1,1). Second, the way you are trying to define a date range is not correct. If your Date function calls were correct, what you would be storing in daterange and daterange1 is not a date range but a boolean true value because January is less than July.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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