topic Re: Arcade Expression For Selecting Future Dates in ArcGIS Online Questions

Arcade Expression For Selecting Future Dates

map16jamie — Fri, 11 Feb 2022 10:20:13 GMT

Hi there, does anyone have a method of filtering a layer that shows features containing a date field which are within the next 'x' days. I know that there is already a date filter which can filter features within the last 'x' days but not within the next.

For example the layer has a field containing future dates and I would like only features to be selected by this field if it is within x days of todays date.

ID	Fruit	Date
1	Apple	13/02/2022
2	Pear	14/02/2022

Any help would be much appreciated

Re: Arcade Expression For Selecting Future Dates

JohannesLindner — Fri, 11 Feb 2022 12:18:00 GMT

var start_date = Text(Today(), "Y-MM-DD") // Today: 2022-02-11 var end_date = Text(DateAdd(Today(), 5, "days"), "Y-MM-DD") // Today +5 days: 2022-02-16 var fs = FeatureSetBy*(...) var future_records = Filter(fs, "DateField BETWEEN @start_date and @end_date")

Re: Arcade Expression For Selecting Future Dates

map16jamie — Fri, 11 Feb 2022 13:15:14 GMT

Hi Johannes,

Thank you for your reply, I forgot to mention I was trying to do this in Mapviewer. I tried the expression above but the function 'Filter' cannot be used within the symbology.

Re: Arcade Expression For Selecting Future Dates

HuubZwart — Fri, 11 Feb 2022 17:28:07 GMT

I don't think this is possible using the regular layer filter in the webmap, but you can tweak the definition expression for the required layer in the web map using ArcGIS Online Assistant (or update the web map via REST interface). You can use any supported SQL statement here such as

DateField BETWEEN CURRENT_DATE() AND CURRENT_DATE() + x

Be aware this makes it impossible to further edit the expression in the webmap interface, you will get an error there if you try to.

Re: Arcade Expression For Selecting Future Dates

JohannesLindner — Mon, 14 Feb 2022 09:00:04 GMT

Ah. In that case:

go to the layer's style settings
Choose "New Expression" as symbol field
edit and use this expression (it will return true or false):

var start_date = Today() var end_date = DateAdd(Today(), 5, "days") var test_date = $feature.DateField return test_date >= start_date && test_date <= end_date

Choose "Distinct Values" as styling option
Style the symbols for true and false
You can also hide the false features by setting the transparency to 100%.

Before:

After applying the Arcade expression:

After hiding the false features:

Note that this approach will probably be slower than just filtering out the undesired features from the layer (see HuubZwart's answer).

Re: Arcade Expression For Selecting Future Dates

map16jamie — Mon, 14 Feb 2022 12:26:31 GMT

Thank you HubbZwart, This has worked 🙂

Re: Arcade Expression For Selecting Future Dates

map16jamie — Mon, 14 Feb 2022 12:26:58 GMT

Thank you Johannes!

Re: Arcade Expression For Selecting Future Dates

map16jamie — Tue, 15 Feb 2022 10:55:56 GMT

Hi HuubZwart,

Thank you for this. Having tried this it works when viewing on Mapviewer but when trying to load this map on Field Maps it does not load the layer at all. Does this method work on Field Maps?

Re: Arcade Expression For Selecting Future Dates

skunkpup — Tue, 27 Sep 2022 04:16:11 GMT

It helped me a lot. Thanks.

fireboy and watergirl

Re: Arcade Expression For Selecting Future Dates

AudreyDawson — Fri, 21 Nov 2025 18:05:14 GMT

Loking for a while for this. Thanks Lucky Days Casino