I have single text for Month.
I want to create View with filter with Month.
Example :Month is equal to the current month
But it is not working.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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]
You have to create the couple of columns with Date time type and calculated type in order to get this.
Start and end of month calculated columns can be used to fix this.
Try this link.