Question about date comparison in sample workflow "Query Features"

S. Burgert

21 November 2025 10:51

Hello everyone,
I have a question about the “Query Features” sample workflow for date queries. There, you can choose whether you want to select features with dates from the last 5 or 10 years or with today's date. Each time, the following query is executed: =`${$dateField.result} >= DATE ‘${$formatDate.formatted}’`, where $dateField.result is the date field of the feature and $format.Date.formatted is the date selected by the user depending on today's date (5/10/0 years earlier than today).

I want to make a query using the same scheme that outputs features from exactly a specific selected date, and I have changed the query accordingly to: =`${$dateField.result} == DATE ‘${$formatDate.formatted}’` and, of course, adjusted the selection in the workflow accordingly.

Unfortunately, I get an error message here. What would be the correct command?

Thanks in advance!

0

• 

  Nico Burgerhart

  21 November 2025 10:56

  Is this for the configuration of the Where clause? As far as I know SQL doesn't use ==, what if you use a single = operator?

  0
• 

  S. Burgert

  11 December 2025 09:25

  Hi Nico,

  unfortunately, doesn't work eather! 

  But generally the SQL statement works with “>”,  “<”, “≤” etc., just not with the “=”

  Any ideas?

  0
• 

  Nico Burgerhart

  11 December 2025 10:21

  Try something like this 

  INSTALL_DATE = DATE '1994-04-29'

  https://services.arcgis.com/p3UBboyC0NH1uCie/arcgis/rest/services/CapitalCity_Web_2_0/FeatureServer/0/query?where=INSTALL_DATE+%3D+DATE+%271994-04-29%27&fullText=&objectIds=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&outDistance=&relationParam=&returnGeodetic=false&outFields=*&returnGeometry=true&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=&defaultSR=&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&collation=&orderByFields=&groupByFieldsForStatistics=&returnAggIds=false&outStatistics=&having=&resultOffset=&resultRecordCount=500&returnZ=false&returnM=false&returnTrueCurves=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=html&token=

   

   

  0
• 

  S. Burgert

  15 December 2025 13:01

  Hi Nico, 

  the problem was that I used the date in the format 01.01.2025 (with dots instead of hyphens between the months and days). So the formatDate function returned this when I entered “L” as the format. Now I use “yyyy-MM-dd” and I get the date with hyphens, but also with the time. Is there a command that only outputs the time, or do I have to shorten the string to the required characters with .substring(0,10)? That seems cumbersome and error-prone to me.

  Thanks for your help!

  0
• 

  Ken Lyon

  15 December 2025 16:55

  If you are trying to convert a date to the “yyyy-MM-dd” format for a WHERE clause, you can use the Format Date activity with a Custom format string to produce the desired output. In your case, using yyyy-MM-dd as the format input, the formatted output would be something like "2025-12-15".

   

   

  0

Du måste logga in om du vill lämna en kommentar.