I want to first start by saying that I???m rather new to Flex Viewer, and don???t have much of a clue to what I???m supposed to do. I have been trying to figure out how to configure the search widget to find dates. No matter how many different ways I try I can???t seem to figure out how I???m supposed to format my expression to get the results back for the date. I???m using SQL 2012 Express, Flex Viewer 3.4, and ArcGIS Server 10.2. I have attached my xml for the search widget.
Your query expression looks fine assuming that the date stored in SQL Server Express has a time portion of midnight. You can try a more open query if you are unsure of the time element of your date field.
where Date_Off between '[value] 12:00:00.000' and '[value] 24:59:59.997'
I keep getting the error " RPC Fault faultString= "unable to complete operation." faultCode= "400" faultDetail="" ". I have my shape and objectid field showing on my feature service
Yes, I tried one for a layer called Circuits using the expression " Circuit Like '[value]' ". I went to my SQL server and took a look at the format that my Date_Off field is in. I took a screenshot so that you can look at the format that it is in.
The first one seem to do the job Robert, but I ran across another problem where the database has stored some of my times as 06:00:00 and 05:00:00. To fix this I used the statement below:
<expression>Date_Off between '[value] 01:00:00' and '[value] 12:00:00'</expression>
