Querying a feature layer based on date?

Question

Using Survey123 Connect, is it possible to query a feature layer based on a dateTime field? I've been trying this, but have not had any luck.

IsmaelChivite · Answer

I realize now that you seemed to be asking a different question originally. Sorry for the guessing. To your question: Yes, the pulldata getRecord operation allows you to query date fields. Essentially, any WHERE statement you can pass to a feature layer, is supported in the pulldata getRecord operation. For example: * pulldata("@layer","getRecord","","RECDATETIME BETWEEN CURRENT_TIMESTAMP - 7 AND CURRENT_TIMESTAMP") * pulldata("@layer","getRecord","","RECDATETIME BETWEEN DATE '2023-04-27' AND DATE '2023-04-29'") Check the Date and Time format section of this help topic for details on the date queries you can make to an ArcGIS layer: https://developers.arcgis.com/rest/services-reference/enterprise/query-feature-service-layer-.htm Important consideration: * ArcGIS stores date values in UTC. * The pulldata() get record operation returns only ONE record.

bsklaohfl · Answer

Thank you for responding. Can this feature be used for a pulldata getRecord calculation?

IsmaelChivite · Answer

Below is an example: Configures the Inbox to retrieve only records where the date value in the install_date column is now older than a week from the current date.