Hey,
I have a list of bookings that have a start & end date and a amount.
I need to split the table so that each month has it's own line and % amount
For example before it would look like this.
<tbody>
</tbody>
but i need to work out how to split it to become like so
<tbody>
</tbody>
<tbody>
</tbody>
I have a list of bookings that have a start & end date and a amount.
I need to split the table so that each month has it's own line and % amount
For example before it would look like this.
Booking | Start Date | End Date |
Booking 1 | 01/08/2017 | 30/11/2017 |
Booking 1 | 01/10/2017 | 30/11/2017 |
Booking 2 | 11/08/2017 | 30/09/2017 |
Booking 2 | 11/08/2017 | 30/09/2017 |
Booking 3 | 07/08/2017 | 31/08/2017 |
<tbody>
</tbody>
but i need to work out how to split it to become like so
Booking | Start Date | End Date |
Booking 1 | 01/08/2017 | 31/08/2017 |
Booking 1 | 01/09/2017 | 30/09/2017 |
Booking 2 | 11/08/2017 | 31/08/2017 |
Booking 2 | 01/09/2017 | 30/09/2017 |
Booking 2 | 11/08/2017 | 31/08/2017 |
Booking 2 | 01/09/2017 | 30/09/2017 |
Booking 3 | 07/08/2017 | 31/08/2017 |
<tbody>
</tbody>
I've added columns that calculates the number of days/month in each row and the amount per day but don't know where to start with using this information to split like this- if anyone can point me in the right direction it would be a great help! Cheers, Tom |
<tbody>
</tbody>