May 10, 2009

Show Last Month SharePoint List Items

This article has been moved to:
http://excel.shilor.org/2010/07/show-last-month-sharepoint-list-items.html
Posted by at

9 comments:

  1. AnonymousMay 11, 2009 at 4:50 AM

    Thanks,
    that what I was looking for, it is really help me.

    ReplyDelete
  2. AnonymousMay 11, 2009 at 8:48 AM

    Thanks, great article exactly what I have needed.

    ReplyDelete
  3. AnonymousMay 18, 2009 at 5:38 AM

    thanks, great article.
    it is posebe to filter the list by week?

    ReplyDelete
  4. UnknownMay 18, 2009 at 1:36 PM

    SharePoint doesn't provide the Week() function to enable applying the same procedure described in this article. Also, there is more than one variation to deal with a week. You may need the past 7 days which is just a comparison between [Today] systems' date and Created + 7, for example. If you need to filter from last Monday to the previous Monday, you can apply the Weekday function which is a bit complicated but if you understood the example you would be able to do it. You can find an example of the usage of that function in another article in this blog.

    Zeev Shilor

    ReplyDelete
  5. AnonymousAugust 22, 2009 at 3:22 PM

    Hi, thanks for this. It works great at the moment. However, do you know how it handles Januarys?

    AFAICS it depends on whether, by adding one to the month, SharePoint rolls the year forward if the month equals 12/December. Any ideas?

    Thanks.

    ReplyDelete
  6. UnknownSeptember 18, 2009 at 11:49 AM

    I am sorry for the late response as I was not notified on your comment and came across it accidentally.

    I had done some testing and apparently SharePoint handles correctly the months around the year start.

    ReplyDelete
  7. RyanNovember 27, 2009 at 6:02 AM

    I've posted about the same technique on my blog and examples for the current week/year

    ReplyDelete
  8. AnonymousJanuary 27, 2010 at 3:34 PM

    Thank you very much for this post.It is simple and quick logic instead of other options we had on internet which were runing around the bush.Intelligent brains!!!!!
    This helped me a lot and saved lot of my time

    ReplyDelete
  9. AnonymousMay 7, 2010 at 10:37 AM

    Great post...but i was wondering I'm having a hard time figuring out 'last 3 months' instead of just 'last month'. Is that something that can be done?

    ReplyDelete

Subscribe to: Post Comments (Atom)