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.

LastMonth_1

Column 1 -> FirstDayLastMonth

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

=DATE(YEAR(CreateDate),MONTH(CreateDate)+1,”1″)

Return Type: Date & Time, but Date only

LastMonth_2

Column 2 -> LastDayLastMonth

Now we create another calculated column with this Formula:

=DATE(YEAR(CreateDate),MONTH(CreateDate)+2,0)

Return Type: Date & Time, but Date only

LastMonth_3

Edit your view:

In our view we check the following conditions:

LastMonth_4

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

LastMonth_5

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.

Karsten Pohnke About Karsten Pohnke
He is Consultant for SharePoint Solutions for collaboration, communication and business processes. He provides his customers applications based on standard features as well as development or combining the power of several microsoft tools like Dynamics CRM. In his free time he tries to collect tipps and worthy experience in this blog.

2 comments on “SharePoint No-Code View for items from last month

  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.

    Cheers

    Ingo

Submit comment

Allowed HTML tags: <a href="http://google.com">google</a> <strong>bold</strong> <em>emphasized</em> <code>code</code> <blockquote>
quote
</blockquote>

Please fill in the captcha: * Time limit is exhausted. Please reload CAPTCHA.