Hey everyone,
I have been at this for hours I just don’t understand why the dropdown menu of the static options (months) is ‘incompatible type’ when I try to add it as constraint.

I have a repeating group with list of transactions, I wanted to add dropdown for the different months, I had it as ‘January’ , ‘February’ etc. I also tried to do it just as number like ‘1’, ‘2’ etc. but every time i go to the repeating group ‘Do a search for’ → ‘transactions’ → ‘Transaction date’ = ‘dropdown month’ but it is greyed out and its labeled at the bottom of it ‘incompatible type’.

What am i missing, how can i fix this?

That’s a list of texts.

This is a date.

You will need a hidden group / expression that takes the month and calculates the start date and end date for that month. That could look like:

Current date time:rounded down to year:+months Dropdown Month’s number (where Month is an option set with each option having a number attribute for the month’s number) for the start date.

This topic was automatically closed after 70 days. New replies are no longer allowed.