Unable to filter features using the date picker in the Filter widget in ArcGIS Experience Builder

Description

In ArcGIS Experience Builder, the date picker in the Filter widget can be used to filter features. The visibility of features is limited to those meeting the expression criteria through interactive date selection, facilitating precise analysis and decision-making. However, in some instances, the date picker is not available in the Filter widget, as shown in the image below.

Cause

The date value in the field is in a string or numeric format instead of a date format. Thus, the date picker is not available in the Filter widget.

Solution or Workaround

To solve this issue, convert the date in the string or numeric field to a date format using the Convert Temporal Field tool in ArcGIS Pro. Share or overwrite it as a feature layer from ArcGIS Pro to ArcGIS Online before creating a web experience in ArcGIS Experience Builder to use the date picker function in the Filter widget.

1. Open the project in ArcGIS Pro and convert the time values of a string or numeric field to a date field before sharing or overwriting it as a feature layer to ArcGIS Online.

2. Sign in to ArcGIS Online and create a web experience from the web map containing the published feature layer with the preferred template.
3. On the Insert widget panel, drag and drop the Filter widget to the canvas.
4. On the Filter panel, configure the required settings.
   1. Click + New filter. The Create new filter panel appears.
   2. On the Create new filter panel, click Select data and select a feature layer. In this example, New_poi_datepicker is selected.

3. Under SQL Expressions, click SQL Expression Builder > Add clause.
4. For the Field input box, select the converted date field from ArcGIS Pro. In this example, date_conv1 is selected.
5. For the Operator input box, select a functional operator. In this example, the 'is between' operator is selected.
6. Click Select source type and select User input.
7. Click More input settings  > Ask for values. Click OK.

5. Save, preview, and publish the web app.

The image below shows the features filtered using the date picker in the Filter widget in ArcGIS Experience Builder.