Your expression can be simplified:
var time1 = Date($feature.enddate)
var dd = DateDiff(time1, Now(), "days")
return When(
dd <= 0, "Inactive",
dd <= 5, "5 days or less to expire",
"Active"
)
You have a few possibilities:
- Just don't symbolize expired points. They will still be in the table, but won't show up in the map.
- If your actual data is in a database, you can use an Attribute Rule (doesn't work for layers hosted in AGOL). You could create an Attribute Rule on your point featureclass like the script below. That will delete all expired points every time you add a new point.
// Calculation Attribute Rule on your poit fc
// triggers: Insert
// field: empty
// exclude from application evaluation
var deletes = []
for(var f in $featureset) {
var dd = DateDiff(f.DateField1, Now(), "days") // replace with the name of your date field
if(dd <= 0) {
Push(deletes, {globalID: f.GlobalID})
}
}
return {
edit: [{
className: "TestPoints", // replace with the name of your point fc
deletes: deletes
}]
}
- You could also write a Python script that deletes all expired points. You can run that script manually or have it run automatically every day or so.
Have a great day!
Johannes
