Arcade Style Expression to filter by date

NygrenOhto — Wed, 18 Oct 2023 11:44:06 GMT

I'm trying to filter out events in my Feature Layer by dates. I am doing this in the ArcGIS Online Map Viewer Style expressions. It works otherwise fine, but this script won't show events that are happening today as Active:

var start = $feature.start; var end = $feature.end; var today = Now(); var event = When( end >= today && start <= today, 'Active', 'Upcoming' ); return event;

The dates are in Esri Datetime format:

start = 10/18/2023 3:00 am.

end = 10/18/2023 3:00 am.

It also doesn't show event that start today and end another day:

start = 10/18/2023 3:00 am.

end = 10/19/2023 3:00 am.

Re: Arcade Style Expression to filter by date

NygrenOhto — Wed, 18 Oct 2023 12:33:00 GMT

I managed to fix this myself by changing the start to this:

var alku = Date(Year($feature.alkaa), Month($feature.alkaa), Day($feature.alkaa), 0, 0, 0, 0);

The problem was that AGOL changed the time to datetime and added the default time to the date.

topic Arcade Style Expression to filter by date in ArcGIS Online Questions

Arcade Style Expression to filter by date

Re: Arcade Style Expression to filter by date