nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Get data from feature layer Query on Date

MJune

I am trying to use the Get data from feature layer to bring back any records that have been created in the last seven days. Every time I try to query on a date file I receive an error "Cannot perform query. Invalid query parameters". If i query the Feature Layer on a field that is not date, i have not issues. It is only when I attempt to query on the date fields. I have tried using the Available Fields/Comparison Type/Search Parameter Value and the Where fields to do this. Does anyone have any ideas?

Below are some screen shots of my flow steps with the formula's shown.

Find more posts tagged with

Accepted answers

Pavel148

Hello,
Thanks for your feedback. I was able to reproduce and identify the issue.
You need to provide the date as a string, such as '2024/01/23'. See the example below.

Please, for now, add single quotation marks (') around the date: for example: '2024/02/14'.

All comments

Pavel148

Hello,
Thanks for your feedback. I was able to reproduce and identify the issue.
You need to provide the date as a string, such as '2024/01/23'. See the example below.

Please, for now, add single quotation marks (') around the date: for example: '2024/02/14'.

MJune

I attempted to use the drop-down and select the field, that did not work either. The created_date is a "Date" field. I was attempting to use a regular date format without success. When i pull back all records, the created_date field is in the Unix Epoch format

PavelJilinski

Hi,
Could you please check a couple of things:
1. If you use the drop-down and select the field "Created_date" does it work?
2. What is the datatype of the field created_date?

From your query, it seems that you are likely passing a Unix Epoch (integer) to a date-type field.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.