Hi,
My question is how you could create a dropdown with the list of months and another dropdown with a list of years and when selecting a value, filter by date. I currently have a date field in my database. I have created an expression rule with a series of filters and one of them is the date with the operator between and the value:
{datetime(year(ri!date), month(ri!date), day(ri!date), "00:00:00"),datetime(year(ri!date), month(ri!date), day (ri!date), "23:59:59")}.
But how could I do it with a dropdown for the year and another for the month? Thank you very much for the help.
Discussion posts and replies are publicly visible
You can simply create two dropdowns for year and date by using the enumeratre function, and then you can pass the selected value of a year in place of 'year(ri!date)' and selected value of month in place of 'month(ri!date)' in your expression rule. For it, you need to create two new rule inputs for month and year, both of type Number (Integer)