We're using ArcGIS Enterprise 10.8 and a Azure SQL Managed Instance. The "in the last" operator is not available. What can be done to enable this operator for our Feature Services?
This "in the last" operator is available, however, in an ArcGIS Online Hosted Feature Service.
Thank you in advance,
Make sure that your Server is enforcing standardized SQL queries. This can potentially affect the behavior of applications like Operations Dashboard from querying by date.
In the Server Administrator directory, navigate to system > properties > update.
Look for a "standardizedQueries" parameter. By default, this parameter is not listed in the properties and is set to "true", meaning that standardized SQL queries are enforced. However, if this parameter is listed and set to "false", you will need to either remove that line, or set it to "true."
See: Enforce standardized SQL queries—ArcGIS Server Administration (Windows) | Documentation for ArcGIS E... for more information.
Hope this helps!