I have an external list which is getting data from SQL Server. The table structure is as follows:
Where InsertDate is the date when record was inserted.
I am trying to show only those records which were entered during last 15 days. So I used the following filter in that external list's view but still it returns all records.
where InsertDate is greater than or equal to [Today]-15
I have checked that all records in SQL Server have InsertDate set to 2013-10-10 which is basically 10 October 2013 and today is 19 Nov 2013 so basically [Today]-15 will return 2013-11-04 so it should not show any record as they were entered in October.