Hi folks, I am challenged by the following task.
My app is the booking engine. I am creating an interface for hosts, and I want to enable them to easily pick dates (not necessarily individual dates) when they are not available. Such dates then would be excluded from proposed booking dates for their customers.
As a date input tool I am using Air Date/Time picker (Air Date/Time Picker Plugin | Bubble). It allows picking single dates and date ranges OR multi-date selector.
Now, when host would use date range or multi-date selectors, those are to be saved into database as, respectively, date ranges, or date lists - that’s how Air Date/Time picker works with batch selections of dates.
Date range: 01/10/2021 - 31/10/2021
Date list: 01/10/2021, 15/10/2021, 31/10/2021
However, for some further use cases, those formats are not very convenient, and I would like to be able to split those by days.
I would like to split date list into individual dates (and be able to store them in DB or use on UI statically), like:
Date list 01/10/2021, 15/10/2021, 31/10/2021 should become
Similarly, I would like to extract dates that comprise the date range 01/10/2021 - 31/10/2021, i.e. obtain separate 31 records that I could then re-save, for example.
Is there a way of achieving this?