Date Calculation in Arcade

[JillianStanford]

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

[DavidPike · Accepted solution]

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

[JillianStanford]

That seems to have done the trick! Thank you!