Date Diff of Feature and Related Table

[JasonCyphers]

How can I calculate the difference, in days, between a date on a hosted feature layer and a date on a related table record?

I have a report point, that captures information about a repair that needs to be made, and a related table that captures information about the repairs that were made.  I'd like to be able to use arcade to determine how many days lapsed between the point being added and the point being repaired.

[jcarlson]

Should be pretty straightforward. With related tables, you just need some way to sort / filter the table, to make sure that you're getting the right record, then just pull out its particular date field.

var repairs = FeatureSetByRelationshipName($feature,"relationshipname")

var recent_repair = First(OrderBy(repairs, 'created_date DESC'))

var repair_date = recent_repair['created_date']

var report_date = $feature['created_date']

return DateDiff(repair_date, report_date, 'days')

[JasonCyphers]

So, if I created an attribute on the point feature called "days_to_repair", I could use the above script in Pro to calculate the values?

[jcarlson]

Yes, I imagine so.

[JasonCyphers]

I tried... no luck 😞

Script works great in a Portal map pop-up, to display the # of days to repair (I was even able to include some code to display the duration in hours if it was less than a day), so not sure why it won't populate the field in Pro.

[jcarlson]

Hm. I would guess it's encountering a null value somewhere. Let's throw in some code to check for values first.

var repairs = FeatureSetByRelationshipName($feature, 'report_repairs')

// check for existence of values in related table first

If (Count(repairs) == 0){
    Console('No related records!')
    return null
} else {
    var recent_repair = First(OrderBy(repairs, 'created_date DESC'))
    // put the rest of the code in these brackets
}

[JasonCyphers]

Thanks for the help.  That still didn't seem to work though. 🤔