I have a number of assessments which cover periods of time.
the attachment shows -
fig 1. the current output of o_assessments table
fig 2. desired output.
I need to be able to list all days which the assessments cover, (ie the days between the start and end date). Hopefully my requirments are clear from the sample data.