Saturday, July 03, 2010

Show Last Month SharePoint List Items

This article has been lost and rewritten (but not tested)

Add these 4 columns: (the last one is needed only for current month calculations in case you need it.)

Date is defaulted to today.
Month =MONTH(Date)
Last Month – Start column  =DATE(YEAR(Date),(Month+1),1)
Last Month – End column  =DATE(YEAR(Date),Month+2,1)

This Month column =DATE(YEAR(Date),(Month)+1,1)





















Create the Last Month  view with the filter:






















Create This Month view with the filter:

2 comments:

  1. Can you please post Filter last month records post ASAP. It's bit urgent. Thanks.

    ReplyDelete
    Replies
    1. Swathi, as per your request I posted the calculation. Please let me know if it works for you.

      Delete

Enter your comment here