Onlinemap date difference and color return

CCWeedcontrol

I been trying to start this basic Arcade expression, well I thought it was basic. I want to display the difference between two date fields and if the number of days are less then 30 display the number of days in blue, if the number of days are over 30 days display the number of days in red. if there is no date in the "PI_DecisionDate1" then return "In Progress".

Here is what I have started, both fields are date fields

 

 

// Write a script to return a value to show in the pop-up.
// For example, get the average of 4 fields:
// Average($feature.SalesQ1, $feature.SalesQ2, $feature.SalesQ3, $feature.SalesQ4)

var startDate = Date($feature["Received_date"])
var endDate = Date($feature["PI_DecisionDate1"])
var age = DateDiff(endDate, startDate, 'days');
return "response time" + " " +age + " " + "Days";

//Less than
IF(age <= 30){
    return age + "#2986cc"
}
//Greater than
IF (age >= 31){
    return age + "D21C06"
}
// else return
// else{
//  return "IN PROGRESS" "F9905D"   
//}

 

 

 

result with the above, but I don't see the days populated when I click on the features on the map. Also, the formula doesn't see right from what I can tell.

Result Value

Result	response time 43 Days
Type	String

jcarlson

The biggest problem here is line 8, in which you have a return. This isn't the same as print() in python; once you hit "return", the expression ends.

How is your popup configured, exactly? Having two strings in your return statement isn't right, in line line 20, and your other returns in the conditional statements will just attempt to join the number to the hex code. I don't see how the hex code is actually being used.

If your popup used an Arcade object, you can use something like this:

var startDate = Date($feature["Received_date"])
var endDate = Date($feature["PI_DecisionDate1"])

var age = DateDiff(endDate, startDate, 'days')

var age_str = Iif(
    !IsEmpty(endDate),
    `Response time: ${Text(age)} Days`,
    'IN PROGRESS'
)

var age_color = When(
    age <= 30, "#2986cc",
    age > 30), "#d21c06",
    "#f9905d"
)

return { 
    type : 'text', 
    text : `<font color=${age_color}>${age_str}`
}