Discussions

Expand all | Collapse all

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

  • 1.  how to make a Dynamic filter by MONTH for a date field

    Posted 05-15-2018 17:14
    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 


  • 2.  RE: how to make a Dynamic filter by MONTH for a date field

    Posted 05-15-2018 17:27
    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])


  • 3.  RE: how to make a Dynamic filter by MONTH for a date field

    Posted 05-15-2018 17:30
    found the answer in the community - should have looked more thoroughly
    thanks


  • 4.  RE: how to make a Dynamic filter by MONTH for a date field

    Posted 05-15-2018 18:03
    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.


  • 5.  RE: how to make a Dynamic filter by MONTH for a date field

    Posted 05-15-2018 18:05
    also great- htanks