https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-cannot-access-data-due-to-arcgis/m-p/1293894#M7881 <P>Hello,</P><P>I have a dashboard that worked all last year, but we recently upgraded to ArcGIS GIS Server 10.9 and now I encountered a <A href="https://support.esri.com/en-us/bug/the-error-message-invalid-data-type-for-expression-expr-bug-000142623" target="_self">BUG-00142623</A> so I now get a 'cannot access data' using a field that is text field with dates.</P><P><FONT face="arial,helvetica,sans-serif" size="4">"The error message, "Invalid data type for expression &lt;expression&gt;." is returned when applying a query in a string field for values formatted as '1/1/2021 12:15:59' with hosted feature services in ArcGIS Server 10.9 relational or spatiotemporal ArcGIS Data Store. "<BR /></FONT></P><P>It is fixed in version 11.0, but our organization will not be upgrading to this for some time. Based on the support page below is the current work around.</P><H2><FONT size="3">"Workaround</FONT></H2><P>Prefix the string with 'N'. For example, Where: test = N'1/1/2021 12:15:59'. "</P><P>How can I apply this in my dashboard for the category selector to work again with the dates as text field? I was trying to use a data expression, but so far have been unsuccessful.</P><P>This is very frustrating since it all was working fine.</P><P>Thanks in advance,</P><P>Kathy</P> Mon, 29 May 2023 18:24:32 GMT kmsmikrud 2023-05-29T18:24:32Z https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-cannot-access-data-due-to-arcgis/m-p/1293894#M7881 <P>Hello,</P><P>I have a dashboard that worked all last year, but we recently upgraded to ArcGIS GIS Server 10.9 and now I encountered a <A href="https://support.esri.com/en-us/bug/the-error-message-invalid-data-type-for-expression-expr-bug-000142623" target="_self">BUG-00142623</A> so I now get a 'cannot access data' using a field that is text field with dates.</P><P><FONT face="arial,helvetica,sans-serif" size="4">"The error message, "Invalid data type for expression &lt;expression&gt;." is returned when applying a query in a string field for values formatted as '1/1/2021 12:15:59' with hosted feature services in ArcGIS Server 10.9 relational or spatiotemporal ArcGIS Data Store. "<BR /></FONT></P><P>It is fixed in version 11.0, but our organization will not be upgrading to this for some time. Based on the support page below is the current work around.</P><H2><FONT size="3">"Workaround</FONT></H2><P>Prefix the string with 'N'. For example, Where: test = N'1/1/2021 12:15:59'. "</P><P>How can I apply this in my dashboard for the category selector to work again with the dates as text field? I was trying to use a data expression, but so far have been unsuccessful.</P><P>This is very frustrating since it all was working fine.</P><P>Thanks in advance,</P><P>Kathy</P> Mon, 29 May 2023 18:24:32 GMT https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-cannot-access-data-due-to-arcgis/m-p/1293894#M7881 kmsmikrud 2023-05-29T18:24:32Z https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-cannot-access-data-due-to-arcgis/m-p/1296266#M7909 <P><SPAN>I upgraded to 10.9.1 over the weekend and I had the same issue with my dashboard.&nbsp; Spent almost a day trying to fix the issue,&nbsp;</SPAN><A href="https://www.esri.com/arcgis-blog/products/ops-dashboard/data-management/using-query-layers-in-dashboards/%C2%A0" target="_self" rel="nofollow noopener noreferrer">Using Query Layers in Operation Dashboard</A><SPAN>&nbsp;method didn't resolve the issue until I see your post regarding the bug.&nbsp; This is what I did, for my event schedule table, I changed the start date field with prefix 'N', 'N' 5/25/2023 and this made the category selector works on the dashboard.&nbsp; At this point, category is displaying as 'N' 5/25/2023, go to the "Selector" tab and under the label to "Load Category" and remove the 'N' from the label.&nbsp; Please see attached images.</SPAN></P> Tue, 06 Jun 2023 15:10:31 GMT https://community.esri.com/t5/arcgis-dashboards-questions/category-selector-cannot-access-data-due-to-arcgis/m-p/1296266#M7909 Pei-SanTsai 2023-06-06T15:10:31Z