3

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.

Improve this question
3
  • 1
    You should be able to use the standard Created column to do what you want. instead of using your Created_Date column
    – Roland
    Commented Dec 21, 2016 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
    Commented Dec 21, 2016 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
    Commented Dec 21, 2016 at 2:13

1 Answer 1

Reset to default
5

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

enter image description here

This should work for you.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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