Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have an external list which is getting data from SQL Server. The table structure is as follows:

Name
InsertDate

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.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

I did some experimentation a while back involving CAML operators with various field types, and it seems that all external columns get passed back to SP as Strings. You can use DateValue(InsertDate) in your formula to get it as a date (possibly using a calculated column if needed).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.