Dashboard date selector - no matching fields

[MatanBenYishay]

Hi, I'm trying to add a date range selector to a dashboard on ArcGIS Online. My feature layer has a date field - verified as a "date only" field - but when I go to the actions tab and target field, there are "no matching options." What do I have to do to get my date field selectable?

[RobertCollins]

Hi, 

Without seeing the configuration of both the feature layer and the dashboard it's hard to ascertain exactly what's going on. 

Would you mind posting a screenshot of the date field not being selectable as a target field? It would also be worth checking to see which fields are selectable as target fields as Category or Number selectors. 

Additionally, it might be worth creating a new Hosted Feature Layer using one of the AGOL Feature Layer Templates (e.g. Debris Reports) which comes with a submitted date field by default. If this can be added as a component in the Dashboard (e.g. a Pie Chart) and then configured correctly in the Date Selector this would point towards the date field in your original Feature Layer perhaps not working as intended. 

Hope this helps get to the bottom of the issue for you. 

[MatanBenYishay]

Hi,

Apparently the date fields in the layer are set up as "date only", not "date and time". That came from the layer as processed by ArcGIS Pro. Would this be a cause for it to not be selectable?

[RobertCollins · Accepted solution]

Hi again, 

Thanks for sharing this. 

I believe that is the cause of the issue in this case. There is an enhancement request (ENH-000167843) which is already in place for this. I would recommend raising a technical support case for your use case to have it attached to the enhancement request. 

In the meantime, I'd perhaps make a duplicate field with "Date" used as opposed to "Date Only" and this will make the field available for use in Dashboards in the way you're after. 

[MatanBenYishay]

Hi, ok, that sorted it. The date field was coming from a table that was queried from a SQL server database, so I had to update that source query to convert the fields to datetime from date. Then ArcGIS Pro (and then Online) recognized them as Date and Time fields, and allowed me to use them as targets of the date selector on the dashboard.