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","<yourlayerURL>","RECDATETIME BETWEEN CURRENT_TIMESTAMP - 7 AND CURRENT_TIMESTAMP")
- pulldata("@layer","getRecord","<yourlayerURL>","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.