https://community.esri.com/t5/arcgis-online-questions/arcade-date-filter-using-between-giving-error/m-p/1257243#M50295 <P>Hello, Im trying to use Filter to summarize the next hours worth of data but getting an error for formatting, does anyone know why that would be? the error does not happen in the sandbox....</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ZachPorteous_0-1676065246713.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/62635iEA28913703868C26/image-size/medium?v=v2&amp;px=400" role="button" title="ZachPorteous_0-1676065246713.png" alt="ZachPorteous_0-1676065246713.png" /></span></P><P>&nbsp;</P><LI-CODE lang="javascript">function reducer(previousVal, val){ return previousVal + val; } function calc1hrSumForManyFields(intervals, fieldsArray) { var fromTime = $feature.datetime; //var fromTime = Text(fromTime) var toTime = DateAdd($feature.datetime, 3540000) // 59 minutes in milliseconds //var toTime = Text(toTime) var sumIntervals = Filter(intervals, 'datetime between @fromTime and @toTime') var sumArray = []; for (var field in fieldsArray) { Push(sumArray, Sum(sumIntervals,field)) } return Reduce(sumArray,reducer) } var allIntervals = FeatureSetByName($datastore, "Interval_20230201",['*'], false); var id = $feature.count_id; var targetIntervals = Filter(allIntervals, `count_id = ${id}`); return calc1hrSumForManyFields(targetIntervals, ['en_inner_volume','ws_inner_volume'])</LI-CODE><P>&nbsp;</P> Fri, 10 Feb 2023 21:43:00 GMT ZachPorteous 2023-02-10T21:43:00Z https://community.esri.com/t5/arcgis-online-questions/arcade-date-filter-using-between-giving-error/m-p/1257243#M50295 <P>Hello, Im trying to use Filter to summarize the next hours worth of data but getting an error for formatting, does anyone know why that would be? the error does not happen in the sandbox....</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ZachPorteous_0-1676065246713.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/62635iEA28913703868C26/image-size/medium?v=v2&amp;px=400" role="button" title="ZachPorteous_0-1676065246713.png" alt="ZachPorteous_0-1676065246713.png" /></span></P><P>&nbsp;</P><LI-CODE lang="javascript">function reducer(previousVal, val){ return previousVal + val; } function calc1hrSumForManyFields(intervals, fieldsArray) { var fromTime = $feature.datetime; //var fromTime = Text(fromTime) var toTime = DateAdd($feature.datetime, 3540000) // 59 minutes in milliseconds //var toTime = Text(toTime) var sumIntervals = Filter(intervals, 'datetime between @fromTime and @toTime') var sumArray = []; for (var field in fieldsArray) { Push(sumArray, Sum(sumIntervals,field)) } return Reduce(sumArray,reducer) } var allIntervals = FeatureSetByName($datastore, "Interval_20230201",['*'], false); var id = $feature.count_id; var targetIntervals = Filter(allIntervals, `count_id = ${id}`); return calc1hrSumForManyFields(targetIntervals, ['en_inner_volume','ws_inner_volume'])</LI-CODE><P>&nbsp;</P> Fri, 10 Feb 2023 21:43:00 GMT https://community.esri.com/t5/arcgis-online-questions/arcade-date-filter-using-between-giving-error/m-p/1257243#M50295 ZachPorteous 2023-02-10T21:43:00Z https://community.esri.com/t5/arcgis-online-questions/arcade-date-filter-using-between-giving-error/m-p/1257253#M50298 <P>$feature.count_id seems to be a text field, but you're missing the quotes in the query.</P><P>In line 20, either add the single quotes around {id} or use the&nbsp;@ notation like you did in line 10</P> Fri, 10 Feb 2023 22:14:08 GMT https://community.esri.com/t5/arcgis-online-questions/arcade-date-filter-using-between-giving-error/m-p/1257253#M50298 JohannesLindner 2023-02-10T22:14:08Z