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:
    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])
  • RobertMayer's avatar
    RobertMayer
    Qrew Assistant Captain
    found the answer in the community - should have looked more thoroughly
    thanks
  • You 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.