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:


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

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


Enter your comment here