I have a Date column where users can enter any date they want, I also have separate column that shows the month of that same date column.
I am trying to create a filter that will count how many items in the month column equals the current month and year we are in. I would like this count to change each month.
example: The user enters 8/16/2018 in the filter it will count it but if the user enters 8/16/2017 it will not count it. Once the month changes to September the count will reset to 0 until the user enters a date in September where it will start counting all over again but with the next month.
The filter I tried to use was: Show items if the following is true [Date column] is equal to ([Today]"MMMM)
But got the error message that the filter was not supported
I'm not sure what I can do to accomplish this. Any help you can give would really go a long way.
Thanks in advance.