Hello, I am trying to use an arcade expression in a Portal web map to symbolize a dataset using a date field. Here's the setup:
ArcGIS Pro map includes parcel geometry feature class, sales history table (both stored in an enterprise geodatabase). Table joined to Parcel geometry via PID field. Table related (in map) to Parcel geometry via PID field. Map published to federated portal server. Parcel layer and Sales History table layer added to web map.
Here's the rub: In the Pro document I have the parcels symbolized by Sales Date field. All of the sales from 2021 are grouped together, 2020, and so on. When I publish though, I run into the issue that web maps don't seem to support symbolizing a date field (though why exactly is entirely beyond me). So I thought of a workaround which involved using separate parcels layers joined to the sales history table, with a definition query targeting the date field in the sales history table, such that for example the 2021 layer would have a definition query like "Tablename.SalesDate=> 2021-01-01 00:00:00" I tried a variety of definition queries and after some research determined that I might not be possible to query a date field in a joined table?
So now I'm trying to see if I can write an arcade clause in the symbology of the actual web map that will target a date by year and symbolize appropriately, but I'm kind of at a loss. Any ideas if this is even possible?