Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I have an app in which I have the delivery date available as a calendar.
I would like to show the user the - possibly multiple - date ranges that are included in the current selection, e.g.
'01.01.2024-31.01.2024, 01.03.2024-31.05.2024'
When displaying these data ranges, however, only filter restrictions on the dates (date, month, year) should be taken into account. Further filter restrictions, e.g. on the product or delivery type, should be ignored. No date gaps should be displayed because there is no delivery for a date.
In the example above, the user would have selected the dates for January, March, April and May - but not for February. In addition, the user may have made numerous other filter selections, but these should be deliberately ignored in the display of the date range. If the user has not made any date restrictions, the entire period available in the calendar should be displayed.
I have tried various solutions (aggregations, alternative states), but I always fail because the date ranges refer to the actual deliveries. For example, days without deliveries result in two periods being displayed instead of one (e.g. '01.01.2024-04.01.2024, 06.01.2024-07.01.2024' instead of '01.01.2024-07.01.2024').
I hope I was able to explain my requirements clearly. I would be happy to receive any good advice.
Thank you very much!
Hi @irma ,
Create a mastercalendar, which will generate all the dates based on the min & max of your delivery date & link this mastercalendar back to the data by delivery date. That way you will have all the dates available to you in the front end..
Regards,
Rohan.