Skip to main content
Question

how to make a Dynamic filter by MONTH for a date field

  • May 15, 2018
  • 0 replies
  • 85 views
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 
    This topic has been closed for replies.

    • DanLadner1
    • Registered
    • May 15, 2018
    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
    • Author
    • Registered
    • May 15, 2018
    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.
    • RobertMayer
    • Author
    • Registered
    • May 15, 2018
    also great- htanks
    Terms & ConditionsAccessibility statement