Database Insert With Sequential 7 Days Plus AM / PM (Eight Rows)

I would like to insert dates into a database using a start date and end date. When entering the dates I would like the start date and each day after until the end date to be entered to each row in the database.

For instance, a conference starts on 11-11-2019 (Monday), it will end on 11-17-2019 (Sunday). The quirky part is that on the last date there will be an AM and PM. This would mean that Sunday would get two entries.

For Example:

Start Date: Nov 11, 2019
End Date: Nov 17, 2019

11-Nov-19 row column’s data…
12-Nov-19 row column’s data…
13-Nov-19 row column’s data…
14-Nov-19 row column’s data…
15-Nov-19 row column’s data…
16-Nov-19 row column’s data…
17-Nov-19 AM row column’s data…
17-Nov-19 PM row column’s data…

If there is data for the columns, it is printed in the appropriate row.
If not, then a note stating “Nothing Scheduled” will be place in the appropriate row and column.

Thanks to all the Wappler Wizards for any help you can offer.

Community Page
Last updated: