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.
-
1It is not working since you have Month as a single text instead of Date Time field– Arsalan Adam KhatriCommented Mar 30, 2015 at 7:04
-
@ArsalanAdamKhatri So,I need to create one more column and field as a today date. And then how is the formula?– user1381501Commented Mar 30, 2015 at 9:03
Add a comment
|
3 Answers
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]
answered Jan 6, 2016 at 18:31
-
I used a very similar calculation to this, however instead of ([Due Date]) I used (Created).– user43832Commented Sep 26, 2017 at 12:05
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
answered Apr 2, 2015 at 18:16
Start and end of month calculated columns can be used to fix this.
Try this link.
