Select for Today in Arcade when data is in local time

MeleKoneya

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 

JayantaPoddar

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'

}