Arcade expression update field

pketeldijk — Fri, 17 Feb 2023 22:31:21 GMT

I have a feature layer with a datefield (inspection_date) and a domain field (maintenance).

The datefield gets populated by related records. When a related record is added the datefield (inspection_date) in the feature layer is updated using an attribute rule.

I would like the maintenance field (which is a domain) to automatically change to ‘inspection needed’ after 20 days of the datefield, by using an attribute rule. I have the following expression, but keep getting an error. Can someone help me out.

var numDays = 20;

var days = DateDiff(‘days’,Date(‘today’),$feature.inspection_date);

If(days > numDays, ‘inspection needed’, $feature.maintenance)

Re: Arcade expression update field

JohannesLindner — Sat, 18 Feb 2023 11:02:40 GMT

You have the wrong order of arguments for DateDiff
Date('today') isn't a thing, Today is
You want to use IIf
You're not using the correct quote marks, but some mixture of apostrophes and accents, but that might be because you posted your code as text

var numDays = 20; var days = DateDiff(Today(), $feature.inspection_date, 'days'); return IIf(days > numDays, 'inspection needed', $feature.maintenance)

topic Arcade expression update field in ArcGIS Pro Questions

Arcade expression update field

Re: Arcade expression update field