nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcade Expression For Selecting Future Dates

map16jamie

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

Najděte více příspěvků označených jako

Mapping

Arcade

Accepted answers

HuubZwart

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.

JohannesLindner

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).

All comments

JohannesLindner

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")

map16jamie

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.

HuubZwart

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.

JohannesLindner

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).

map16jamie

Thank you HubbZwart, This has worked 🙂

map16jamie

Thank you Johannes!

map16jamie

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?

skunkpup

It helped me a lot. Thanks.

fireboy and watergirl

AudreyDawson

Loking for a while for this. Thanks Lucky Days Casino

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.