SharePoint No-Code View for items from last month

There are a plenty ways of building some cool listviews and look at your data – it’s a powerful report builder if you know how to use it and also use all opportunities you have. In my last posts i wrote about conditional formatting. Today i would like to show you how to build a view for a certain month. In this example we build a view for the last month. So we would like to see every item where the last month is mentioned in the date column we created (CreateDate).

How would it look like? Ok let’s assume we have March 2015 and we would like to see all items from february 2015. That is our list.


Column 1 -> FirstDayLastMonth

At frist we create a c column as calculated with the following Formula:


Return Type: Date & Time, but Date only


Column 2 -> LastDayLastMonth

Now we create another calculated column with this Formula:


Return Type: Date & Time, but Date only


Edit your view:

In our view we check the following conditions:


Result now filters all items for the last month, in this case it displays only items where the February is in the column CreateDate


That’s really easy right?

The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.

About Karsten Schneider 312 Articles
Consultant for Microsoft 365 Applications with a strong focus in Teams, SharePoint Online, OneDrive for Business as well as PowerPlatform with PowerApps, Flow and PowerBI. I provide Workshops for Governance & Security in Office 365 and Development of Solutions in the area of Collaboration and Teamwork based on Microsoft 365 and Azure Cloud Solutions. In his free time he tries to collect tipps and worthy experience in this blog.


  1. Hi all,

    this really IS easy, but please be aware, that for german installations the commas within the formular have to be replaced by semicolons.



Leave a Reply

Your email address will not be published.