how to make a Dynamic filter by MONTH for a date field
How can I get a date field dynamic filter - that lists filters for example Jan 2018 Feb 2018 Mar 2018 etc instead of a date range
Forum Discussion
I think creating a formula field to return that value would work (so you'd use the formula field as the dynamic filter).
Try this:
Try this:
Case(Month([Date field]),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December") & " " & Year([Date field])