Cannot Query by Date Range

Question

Cannot query Survey123 Web App results by date range. Get message:

The feature is not available. The creation date field cannot be found in the feature service.

Survey results are being written to a related table.

Feature Layer Settings:

GISManager4 · Answer

When I try and enable Keep track of who created and last updated features; I get Save wasn't successful. Try again later.

The Layer within the feature service has: CreationDate, Creator, EditDate, Editor

Jim Moore · Answer

Hi

The date filter uses the CreationDate field, which is a system-managed field added to a feature layer or table when editor tracking is enabled (in addition to Creator, Editor and EditDate). To enable editor tracking, select the Keep track of who created and last updated features option. See the ArcGIS Online documentation for more info: Manage hosted feature layers—ArcGIS Online Help | Documentation

Editor tracking is enabled by default for a feature service created when a survey is published from Survey123 Connect or the web designer.

Best regards,

Jim