Our list has a view threshold of 20,000 items, which we usually reach every 12-15 days. Right now it's at 17,456 items and the oldest items are from December 7. So I want to create a filter to display items from the last 7 days including today's. The default Created column showed both date and time, so I created a new calculated column called Created Date with the formula =[Created] and set it to display date only. Then I tried to create a filter like Created Date is great than or equal to [Today] AND Created Date is less than or equal to [Today]+7 but it's not working. It's only showing records as old as about 10 hours ago, roughly 2000 records. How do I solve this?

Note 1: This is the only filter on the list, so there's nothing that should be conflicting with this one.
Note 2: I only have basic modify view option, modify in sharepoint designer (advanced) is disabled.

  • 1
    You should be able to use the standard Created column to do what you want. instead of using your Created_Date column – Roland Dec 21 '16 at 0:12
  • @Roland really? I read that it wouldn't work using the standard Created column since it contains both date and time. But I guess I can give it a try, thanks. – cassidymack Dec 21 '16 at 1:34
  • 1
    That might be the case depending on how sensitive to the time you want it as when Today is created it will be created with a time as well i believe. But for 99% of the time this should be perfectly fine.. – Roland Dec 21 '16 at 2:13

You should modify your filter to be [Today]-7 , see the details below:

enter image description here

This should work for you.

  • So just the one statement? I don't need AND / OR ? – cassidymack Dec 21 '16 at 1:35
  • 2
    This will get you all the items that were created in the last 7 days. – Mohamed Derhalli Dec 21 '16 at 1:36
  • 2
    Make sure to have no spaces between the number and the keyword, so make it like [Today]-7 .. without spaces – Mohamed Derhalli Dec 21 '16 at 1:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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