Goodmorning everyone . I have a little big problem on my app. I am setting up a do search for to search for certain menus within my database. Now I should set that all menus that have the date AT LEAST equal to today’s date and lower instead of the menu end date should be found. I am going crazy but I cannot find a solution to this problem.
For the moment I have set that it must show me all the menus where the END DATE is greater than or equal to the current date.
I can’t understand, however, how to add a second constraint where I specify that the START date must be AT LEAST the same as the current date and less than the end DATE. Help me please
unfortunately this is not a solution since setting the date> = to the current date, I would also see all the menus that have a departure date from the next day (or days after the current date). In addition, I cannot set that the date is less than the date_end because it is a constant that I do not have access to, on the contrary, I am trying to display the menu based on that parameter.
unfortunately it is not a solution to my problem, since setting the date on> = I also see all the menus that should start from the following days. I tried another solution, I created in my table another field called “range_validity” which set my date as the start date, and my date_end as the end date. The problem now is that I can’t set the range
because I don’t have access to this 2 information yet, since I’m looking for the Menu of the day and I have no way of tracing back to those values that are different for each menu
mmm please i just can’t get there. Calculate that all the menus I create always have the same validity time (only the day changes) and they are always valid from
should these be the conditions? setting down to day? knowing that they are always valid from 12.00 AM on the set date until 11.59PM on the set date?
Anyway thank you very much, if this is the solution you saved me.
Maybe the restaurant must not be in the constraint or can be related from the parent group or another group or dropdown that you used to select the restaurant.
Can you share pictures from the editor to see how is your desing or how you are displaying this info?
the main problem of the filtered is that I do not have access to these values that I need, as the “Menù of the day” that I want to print are within a repeating group and since I am trying to set up the repeating group just to find the correct “Menù of the day” I do not yet have access to the starting and ending dates of each single menu. In fact, even with the filtered I can’t add the range I need
thank you so much for your help . The problem is that today the menus that should have started from yesterday have disappeared because I have the condition that “departure date” must be greater than or equal to the current date. So the menus created yesterday (although they should be valid until 10 August) are no longer displayed.
I totally don’t get this thread, but don’t you have your conditions just plain wrong?
If “Date” is “starting date” (meaning the menu became available on that date) and “Date_End” is the point after which the menu is no longer available, a Menu is available:
If Date (start date) is in the past (that is, LESS THAN today’s date). AND
If Date_End is in the future (that is, GREATER THAN today’s date).
i’m really stupid. The solution has always been there, thank you very much for your help. At the end of the games I had also found another solution that was this
but at this point I will keep yours. I don’t really know why I didn’t think of it before. I thank you very much and thank the bubble community that has gone out of their way to help me. Thank you !
In addition to Jici
