topic Re: Date Diff of Feature and Related Table in ArcGIS Pro Questions

Date Diff of Feature and Related Table

JasonCyphers — Thu, 18 Aug 2022 15:04:07 GMT

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.

Re: Date Diff of Feature and Related Table

jcarlson — Thu, 18 Aug 2022 18:12:41 GMT

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')

Re: Date Diff of Feature and Related Table

JasonCyphers — Thu, 18 Aug 2022 18:38:09 GMT

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?

Re: Date Diff of Feature and Related Table

jcarlson — Thu, 18 Aug 2022 18:46:52 GMT

Yes, I imagine so.

Re: Date Diff of Feature and Related Table

JasonCyphers — Fri, 19 Aug 2022 11:52:18 GMT

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.

Re: Date Diff of Feature and Related Table

jcarlson — Fri, 19 Aug 2022 13:17:21 GMT

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 }

Re: Date Diff of Feature and Related Table

JasonCyphers — Fri, 19 Aug 2022 16:40:58 GMT

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