Forum Discussion
- DanLadner1Qrew TraineeI think creating a formula field to return that value would work (so you'd use the formula field as the dynamic filter).
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]) - RobertMayerQrew Assistant Captainfound the answer in the community - should have looked more thoroughly
thanks - ForrestParkerQrew CadetYou could also create two fields; one for month and another for year. You could include them both as dynamic filters and neither would ever get too long. Just remember to do a text field for the year since numeric fields aren't allowed as dynamic filters.
- RobertMayerQrew Assistant Captainalso great- htanks