Date Diff of Feature and Related Table

Question

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.

JasonCyphers · Answer

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

jcarlson · Answer

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 · Answer

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.