idea Map Viewer - Date Filter (today/after today/Date Range) in ArcGIS Online Ideas

Map Viewer - Date Filter (today/after today/Date Range)

SteveCole — Wed, 20 Sep 2023 18:15:00 GMT

The new Map Viewer (both AGOL and Enterprise) should have the ability to filter a layer's data by a date relative to the current date. For example, I have a layer of construction closures that have a start and endate as attributes. I want to apply a filter such that only records where the closing date occurs in the future would be displayed. With Map Viewer Classic, I believe you could edit the map's JSON in AGOL Assistant to implement this but I don't know if this is still possible with the new Map Viewer. Either way, users should have to hack their maps for a pretty standard date filter option.

The choices would be something like:

"occurs on.." <Specific Date | Today>

"occurs on or after.." <Specific Date | Today>

"occurs on or before.." <Specific Date | Today>

It would be nice to also have some addition variants like "within the next week | within the next month" but a relative option like "today" should be the absolute minimum.

Re: Map Viewer - Date Filter (today/after today/Date Range)

JörgMoosmeier — Thu, 21 Sep 2023 10:15:51 GMT

Perhaps I read your idea wrong, but isn't that already possible?: https://doc.arcgis.com/en/arcgis-online/create-maps/apply-filters-mv.htm

Re: Map Viewer - Date Filter (today/after today/Date Range)

ChristosP — Thu, 21 Sep 2023 12:32:08 GMT

This feature is desperately needed to filter large, time-enabled datasets to show only the most recent data.

It looks like Experience Builder offers some more functionality but it's needed in the web map viewer as well!

The article referenced below states that "You can use the in the last and not in the last operators", which would be great, but we don't see it in our Portal for ArcGIS 11.0. Maybe a versioning thing?

Re: Map Viewer - Date Filter (today/after today/Date Range)

JörgMoosmeier — Thu, 21 Sep 2023 13:01:59 GMT

I have checked with my AGE 11.1 installation. For Filter it has the same options (see screenshot).

I don't have a 11.0 installation at hand, but at least the help for 11.0 says the same as for 11.1.

Something seems to be wrong

Re: Map Viewer - Date Filter (today/after today/Date Range)

SteveCole — Thu, 21 Sep 2023 14:50:12 GMT

@JörgMoosmeier I'm using Enterprise 10.9.1 but, to my knowledge and experience, no, you cannot do what I have described either in Portal of AGOL. I just logged into AGOL and then added an earthquake layer to my map. For a filter, I tried to just filter that layer for records from today and it's still asking me for the specific date. There is no relative "today" option- you must select or specify an actual date.

The Help document you linked to mentions options such as "is on" or "is after" but in all these cases, you have to supply a hard date value (9/21/2023). I want a relative value ("today") so that the map is smart enough to adjust rather than me having to manually update it.

Re: Map Viewer - Date Filter (today/after today/Date Range)

JörgMoosmeier — Thu, 21 Sep 2023 15:34:33 GMT

Allright, I have done the same with this map (in ArcGIS Online, don't know if it is possible in 10.9.1):
https://www.arcgis.com/apps/mapviewer/index.html?webmap=d98f65bc89884e94821cf1815a73cd78

this is the filter for the layer:

The feature layer refreshes every 30 seconds.

And while I'm looking at the map, features come and go, dependent on Event Time. There seems to be a little lag time in updating the table.

So for me relative time filter into the past are working. There is no filter for '1 hour in the future' (for planed events in the future), I think this has to be done with a little Arcade Scripting.

Re: Map Viewer - Date Filter (today/after today/Date Range)

SteveCole — Thu, 21 Sep 2023 15:45:11 GMT

@JörgMoosmeier So you would agree that the filtering options are available when speaking about past events but not for events in the future? That seems to validate my Idea. I'm more concerned about filtering *future* events than I am the past (road closures, etc).

Re: Map Viewer - Date Filter (today/after today/Date Range)

JörgMoosmeier — Thu, 21 Sep 2023 16:08:57 GMT

Hi @SteveCole ,

yes, in Map Viewer there is currently no relative filter for events in the future (from now).

You can do this in Dashboards, not directly for the map, but you can set relative filters (also into the future) for eg. lists or you can define data expressions.

Re: Map Viewer - Date Filter (today/after today/Date Range)

SteveCole — Thu, 21 Sep 2023 17:32:50 GMT

@JörgMoosmeier Well, as someone who work's on the Portal side of the equation, I know I have a long wait for a lot of the functionality I need (Q4 2024 for WAB->EB parity for example) so I'm stuck for now.

I am able to edit the JSON of my map and, for now, I'll just have to use this AGOL ASSISTANT workaround. Here's the definition expression to use for an end date which is today, or in the future:

"definitionExpression": "endDate >= CURRENT_TIMESTAMP"

Re: Map Viewer - Date Filter (today/after today/Date Range)

WilliamRockwell1 — Mon, 27 Nov 2023 18:06:28 GMT

I don't know how "in the last" and "not in the last" (minutes, hours, days, weeks, months, years) is an option, but going forward in time isn't.

Do people not plan things in the future? Are there not future events and the needs to weed out past events? Crazy.

Please implement this. It shouldn't be a huge lift programmatically.

Re: Map Viewer - Date Filter (today/after today/Date Range)

DavidSolari — Wed, 20 Mar 2024 18:42:33 GMT

Tweaking a layer based on the current datetime relative to a field in the layer is a common request in my org. Usually it's a symbol that we set using Arcade but filtering comes up too and jumping into AGOL Assistant is less than ideal.

Re: Map Viewer - Date Filter (today/after today/Date Range)

Amanda__Huber — Tue, 30 Apr 2024 19:20:02 GMT

@JörgMoosmeier where are you seeing these additional expression filters?

We're using ArcGIS Online and only see these options for date time fields:

We're looking for an expression that is "in the current year". I don't think that exists yet so maybe that should be a separate idea post?

Thanks,

Amanda Huber

Re: Map Viewer - Date Filter (today/after today/Date Range)

Megan2 — Fri, 18 Oct 2024 13:38:16 GMT

Also jumping on this! I made a Survey123 that has to do essentially with permits. I have one copy of the layer in my web map set to show features that have a start date "in the last 21 days" which indicates they are currently active, as the permit is only good for 21 days. However I'd also like to be able to filter by the End Date field, ideally with a filter of "in the next X days" so I can have staff easily see permits that are expiring soon so the people who requested said permits can be notified of the upcoming expiration. (Would love to set something up to automatically send emails but at this time we don't have access to Power Automate or anything; that's a whole different story)

"in the last" is a good start, but I think "in the next" is also desperately needed.

Re: Map Viewer - Date Filter (today/after today/Date Range)

Teresa_Blader — Mon, 21 Oct 2024 21:24:54 GMT

I'd like to set a filter based on a field of expiration dates. I only want to show features in the map that are not "expired" based on the date. I'd like to say "is after now" but I only get specific date options to enter. Other options might be today, yesterday. Basically similar options as "in the last". However, "in the last" or "not in the last" is limiting because it creates a range and features show up outside of that range, so I have to do something ridiculous like 2628001 minutes or something.

Re: Map Viewer - Date Filter (today/after today/Date Range)

Megan2 — Fri, 22 Nov 2024 18:52:24 GMT

@Teresa_Blader

Yep, I'm literally back again and needing that same functionality. I'm working with permits and need to filter by only the permits currently active or that are upcoming, so while I see a "is after or equal to" option, it only then allows the user to pick a static date and time. I need "TODAY" to be an option for that! I need to be able to filter and show only the features whose End Date (a field in the data) "is after or equal to" TODAY.

I was able to set up my symbology for all of this in Arcade, but the Experience Builder I've made using this web map has been showing all features in the Table widget and seems to be controlled by setting up a Filter for the layer in the web map. Which I'm unable to do, due to this limitation. Ack.

Re: Map Viewer - Date Filter (today/after today/Date Range)

DenisLalonde — Thu, 24 Apr 2025 20:28:29 GMT

Bumping this Idea. Somewhat surprised that this isn't "out of the box" yet.

Re: Map Viewer - Date Filter (today/after today/Date Range)

mwartman_grey — Mon, 26 May 2025 12:20:10 GMT

@Amanda__Huber, I've added an idea for filters like "in the current year": https://community.esri.com/t5/arcgis-online-ideas/map-viewer-dynamic-date-filter-based-on-current/idi-p/1617769

Re: Map Viewer - Date Filter (today/after today/Date Range)

BrandonGuo — Mon, 04 Aug 2025 01:59:06 GMT

I can't believe there's no option to filter event happens today. There's no filter like "time" is on today.

Re: Map Viewer - Date Filter (today/after today/Date Range)

MeganHicks — Fri, 20 Feb 2026 12:03:42 GMT

I also need this functionality. I have filters on my data to show only items with end date from the past week so the users don't get overwhelmed. But sometimes they'll add the end date in the future accidentally, which makes it disappear from the map. I have to go in and manually change it for them. I was hoping to change my filter to "in the last week OR after now" but that's not an option. Hoping this very basic query can be added!

Re: Map Viewer - Date Filter (today/after today/Date Range)

MappingDepartment — Wed, 01 Apr 2026 23:14:39 GMT

I do need this functionality. It's included in dashboards and experience builder but why not the webmap.