topic Re: Date Calculation in Arcade in ArcGIS Dashboards Questions

Date Calculation in Arcade

JillianStanford — Thu, 20 Apr 2023 20:50:55 GMT

Hi,

In a data expression, I'm filtering a feature layer of 911 calls to those in the last 24 hours. The filter often returns more records than I think it should

Here is the Arcade:

var portal = Portal("https://arcgis.com"); var accidents = FeatureSetByPortalItem(portal, "********",1, ['*'], true) var t1 = Text(Now(),'Y-MM-DD HH:mm') var t2 = Text(DateAdd(t1, -24, 'hours'),'Y-MM-DD HH:mm') var sql = "call > @t2" Console("call > " + t2) var recent_accidents = Filter(accidents, sql) for (var s in recent_accidents) { Console(Text(s.call,'Y-MM-DD HH:mm')) }

Here are the results:

I can't figure out why the call at 14:02 is not being filtered out, even though it occurs before 15:33.

Can someone point out my error here?

Thanks!

Jill

Re: Date Calculation in Arcade

DavidPike — Thu, 20 Apr 2023 22:33:48 GMT

Even with the comparison being done on text forms of the datetime, the formatting should allow for the comparison to work as intended. I'm wondering if timezones are a factor here and ToUTC() should be implemented.

var portal = Portal("https://arcgis.com"); var accidents = FeatureSetByPortalItem(portal, "********",1, ['*'], true) var t1 = Text(ToUTC(Now()),'Y-MM-DD HH:mm') var t2 = Text(DateAdd(t1, -24, 'hours'),'Y-MM-DD HH:mm') var sql = "call > @t2" Console("call > " + t2) var recent_accidents = Filter(accidents, sql) for (var s in recent_accidents) { Console(Text(ToUTC(s.call),'Y-MM-DD HH:mm'))

Re: Date Calculation in Arcade

JillianStanford — Fri, 21 Apr 2023 17:00:45 GMT

That seems to have done the trick! Thank you!