Filter and/or Symbolise features before/after TODAY()
It's been a while since anyone seems to have requested this. I'm setting up a simple feature service with points that show the location of Traffic Management Plans. Each point will have an expiry date. I'd like to be able to either:
A) Symbolise points as Current or Expired based on their expiry date (before/after TODAY)
B) Filter hosted views to only show features that are Current (Date is after TODAY) or Expired (Date is before TODAY)
The only way I can figure out how to filter like this is to use the "in the last" option and set a timeframe that exceeds the expected usage window for this data (i.e. 1000 years). Below is an example of the filter setup to show Expired features:
Surely a more elegant solution would be to simply have the option where DateField "is before Today" or "is after Today". I understand "Today" could be too course for some applications, and you might want it to be based on the current time as well, so maybe a "Now" option could be included for that level of detail.
I would also like the same functionality in the symbology. Currently it seems I can only group dates based on dates that already exist as attributes. A simple symbology arrangement where features a coloured one way or another based on the current date and time would be really useful in this situation where I still want to see all the features without the need for filtered hosted views. It essentially already exists (Before and after theme) but requires a set date as the dividing point.
