topic Re: Select for Today in Arcade when data is in local time in ArcGIS Online Questions

Select for Today in Arcade when data is in local time

MeleKoneya — Fri, 13 Jan 2023 23:25:22 GMT

I published a feature layer to AGOL via ArcGIS pro and see in the data panel that our times are in local time which is what I wanted.

I am trying to grab only today's records using this:

var time = -1

var units = 'days' //milliseconds, seconds, minutes, hours, days, months, years

var dateField = "Today"

var pastDate = DateAdd(Date(), time, units)

if($feature.dispatch_date > pastDate)

{

return dateField

}

The results are close to what I would expect 110 records, but it really should be 75.

I am guessing it is doing some UTC assumptions on my dates, but I am lost as to how to fake it to use the stored value which is local as far as I can tell since I published it that way.

Thanks,

Mele

Re: Select for Today in Arcade when data is in local time

JayantaPoddar — Sat, 14 Jan 2023 05:22:17 GMT

The following expression converts UTC date to to Local Date. Replace Timestamp() with your date variable.

ToLocal(Timestamp())

https://developers.arcgis.com/arcade/function-reference/date_functions/#tolocal

Re: Select for Today in Arcade when data is in local time

MeleKoneya — Sat, 14 Jan 2023 16:40:12 GMT

I think I am getting closer to what I wanted.

I had to get just the date part of today.

2023-01-14T00:00:00-07:00 with the Text Function

var dispatch = $feature.dispatch_date

var Today = Date(Text(now, "Y-MM-DD"))

If (dispatch > Today)

{

'today'

}

else

{

'past'

}

Mele

Re: Select for Today in Arcade when data is in local time

JayantaPoddar — Sat, 14 Jan 2023 19:49:28 GMT

Assuming the dispatch_date field also has Date datatype, you can check the following expression

var dispatch = $feature.dispatch_date var dispatchdate = Concatenate(Year(dispatch),'-',Month(dispatch)+1,'-',Day(dispatch)) var currentdate = Concatenate(Year(Today()),'-',Month(Today())+1,'-',Day(Today())) If (dispatchdate == currentdate) { 'today' } else { 'past' }