ArcGIS Data Pipelines- Filter By Attribute- Expression for Current Year *Equivilancy Issue*

[Amanda__Huber]

Hello, 

It appears there is no functionality for the expression builder to accomodate "Current Year". This functionality is built into other Esri applications and has a very strong use case in your application as well. This seems to be an equivilancy issue. 

This option is critical, as many individuals have a need to filter based on annual operations/summaries. 

There is no option to set current year or even filter for year. 

Example of ArcGIS Dashboard's Expression builder- 

Please advise, 

Amanda Huber

[BethanyScott]

Hey @Amanda__Huber ,

Thank you for reaching out with this feedback.

While querying for "this year" is not currently supported, what you could do is add a filter that uses an "is between" clause. This can be used to find records that fall within a specific date range, such as January 1, 2024 - December 31, 2024.

In Query builder, it would look something like this:

This query would need to be updated in the data pipeline yearly, but hopefully it can get you one step closer to your desired results.

Thanks again for reaching out! We value your input.

Bethany

[Amanda__Huber]

Hi @BethanyScott 

Thanks for the quick response! 

Unfortunately we'd like to avoid having to update the query yearly. This would somewhat defeat the purpose of it being automated/in Data Pipelines since we could just run this query manually using ArcGIS Pro GP tools. We'd need it to be "current year" similar to how "in the last 1 year" expression functions across other Esri expression builders. 

Thanks, 

Amanda Huber

[Amanda__Huber]

Update- 

Exciting news! It looks like the Esri Pipelines Team implemented this in the Feb 2025 AGOL update. Learn more about it here: https://www.esri.com/arcgis-blog/products/arcgis-online/announcements/whats-new-in-arcgis-data-pipel...