Do you mean that you can not filter data based on date type of SQL?
Please note that:
Direct date filters do not work for SQL Server. However, you can create a calculated column that will work. For instance, ALTER TABLE myTable ADD DateAsInt AS (YEAR([date]) * 10000 + MONTH([date]) * 100 + DAY([date])) and then filter on the calculated number column.
//modify your date field data to value and compare this value
I changed the formula as per your instructions and while there is no error, it did not return any records. I even removed the projID criteria and still nothing.
I then used AddColumns on a DataTable control to look at the data. It shows the column but only some data at the beginning of the table (perhaps 500 records) which represents data for the year 2010.
Now I see in the documentation there are "throttling limits" of 500. So now I how do I filter properly and see records. My objective was to create a filter form so that the user would select a project and a date range to see the tasks for that period of time.
I thought this would be a really easy and straight forward application but it seems to me this is not simple.
Is the sql date filter being looked into? The current method cannot be efficient if your always converting the date format.