I have a date field that contains day, month and year.
I would like to filter by month and year and set this directly in the filter, but I am getting only day in time granularity.
Hi Max! Thanks for your answer.
Your solution can work, but I would love to be able to choose between date&time ranges -which in the control translates to a date picker- and a date dropdown control with multiselect while still being able to choose the date format.
I have created a calculated field where I have MMM-YYYY but because it is a string, in the filter control the dates are ordered alphabetically. So for example, in my control Iām getting the date values not in date order but in alphabetical order.
I have managed to solve this by using the month number instead of month name, but again, would be much better to have month name.
Yes. I understand that I can change the format, thank you for the information!
I also meant to reference this:
As I am only selecting entire months, it can be confusing to have the calendar view control. I was wondering if there is a way to have a date filter control in some other fashion, such as a dropdown.