3

I have single text for Month.

I want to create View with filter with Month.

Example :Month is equal to the current month formula is =MONTH([Today])

But it is not working.

  • 1
    It is not working since you have Month as a single text instead of Date Time field – Arsalan Adam Khatri Mar 30 '15 at 7:04
  • @ArsalanAdamKhatri So,I need to create one more column and field as a today date. And then how is the formula? – user1381501 Mar 30 '15 at 9:03
6

You need to add two calculated columns that will work out the start and the end of the month. (This example uses [Due Date] but you can use any date/time column)

"Start of Month" =DATE(YEAR([Due Date]), MONTH([Due Date]), 1)

"End of Month" =DATE(YEAR([Due Date]), MONTH([Due Date])+1,1)-1

Then you setup a filter in your view for...

"Start of Month" is less than or equal to [Today] AND "End of Month" is greater than or equal to [Today]

  • I used a very similar calculation to this, however instead of ([Due Date]) I used (Created). – Nullldata Sep 26 '17 at 12:05
  • 1
    Once again, this saved my bacon! – Nullldata May 13 at 13:37
1

You have to create the couple of columns with Date time type and calculated type in order to get this.

Check this

A sharepoint list view of the current month

List View: Automatically Filter by Current Day, Month or Year

0

Start and end of month calculated columns can be used to fix this.

Try this link.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.