RPG: Compare Numbers From Dropdown to Dates

Hi, everyone:

I have two dropdowns that references months and years. The user is supposed to be able to choose a month and a year from those dropdowns so that the repeating group lists all the members that have expiration dates within that chosen month and year. For example, if September (9) and 2023 are selected, respectively, then the RPG lists all the members that have expiration dates between 9/1/2023 and 9/30/2023.

Note: Not sure if the button is necessary.

Right now, the months and years are represented as numbers, but the expiration date is stored as dates. I think I need to somehow convert the month and year from number to date, but nothing seems to work.

Any ideas?


Hi there, @cinji18… the way you have it now, you would need to add an advanced filter to the repeating group’s data source, and the filter would look something like this.

If you haven’t used an advanced filter before, note that the filtering takes place on the client (browser) side. So, the search will return all of the relevant items in the database to the client, and then the filter will be applied, and that could have a performance impact, depending on how many items are returned in the search.

The above being said, you might want to consider storing the expiration month and year in their own fields because then the following constraints on the search would do the trick.

Oh, and no, the button isn’t necessary.

Hope this helps.


1 Like

Thanks. I got the first solution to work.

1 Like