Arcade Expression in AGOL

AshleyPeters

I am trying to write an expression for use in the new map viewer to show work that has been done within the last month, three months, etc. The expression found here does most of what I need. However, most of my locations have not yet been visited and with this expression they are showing up as having been visited over 100 days ago and not in 'other values'. I've tried a few different ways to add phrasing to the expression that will create a new symbol for locations with null date fields, but that isn't working. This is likely due to lack of knowledge on my part as this is the first time I am trying to use Arcade. Is it possible to create symbology for locations with null date fields?

kenbuja

Which type is not being returned?

BTW, you can simplify your expression this way. On line 5, you don't need to check if the value is greater than 20, since that was already checked in line 3.

if(isEmpty($feature.cleandate)) {
  return "Not yet surveyed";
} else if (DateDiff(Now(), Date($feature.cleandate), 'days') <= 20) {
  return "Surveyed within the last 20 days"; 
} else if (DateDiff(Now(), Date($feature.cleandate), 'days') < 35) {
  return "Surveyed between 20 to 35 days ago" ;
} else {
  return "Surveyed more than 35 days ago";
}