ArcGIS Online June 2016 date filter "in the last" not working

[DublinOhio]

In ArcGIS Online June 2016 update, we have attempted to use the new "in the last" / "not in the last" functionality and it will not work. It gets rid of all of our points. Or throws a data error. The other date filters work. 

Feel free to test on the field "DateFiled" in this service (try in the last 10 months) http://mapping.dublin.oh.us/arcgis/rest/services/Planning/MapServer/6 

[ChrisWhitmore]

Hi,

For other services, the "In the last" date filter is working. Sounds like either a service / server specific issue. or maybe database specific. Your best bet is to contact Tech Support - they'll be able to troubleshoot.

Thanks,

Chris

[DublinOhio]

Thanks Chris, will do and will post results here.

[JeffWard]

I am attempting to create a community events map that has a filter which excludes events that have already happened.  I was able to create a filter that shows events not in the last 24 months, but this filter excludes events that are happening that day - I would like the events that are currently happening to be shown on the map.  Is there any way to get a filter setting that would modify the "after" operator and allow you to make a selection like "today", or create a new operator that would be "after and including" with selections like "today" and "yesterday"?

[KellyGerrow]

Hi Jeff,

How are you using the filtered data, in a web map or to present in a web application? Check out the time aware configurable app: http://www.arcgis.com/home/item.html?id=b70d83ba89db4f8a97427ee237a1e60c  There are configurable options for Live Data, which may help to display data happening today or yesterday.

If this doesn't meet your needs, consider logging an idea on ArcGIS Ideas​

-Kelly

[MarcGraham1]

from here: https://community.esri.com/ideas/11755  it appears that filter "in the last" only works with hosted feature services.

[Anonymous User]

I would also like to use the "in the last" on a ArcGIS Server feature service. Why is this only available on an ArcGIS Online hosted feature when the other date querying statements are available regardless of data source?