I have a table that writes my records where one column writes the data_inicial
and another column the data_final
.
I need to generate a report where the user searches all the records that were between the period of eg 03/03/2017 to 03/31/2017.
What I needed is to get the records that even having started before that period occupied days in my 03 month. If I use for example data_inicial between 01/03/2017 and 31/03/2017
, my records that had start date 2/27/2017 and end date 01 / 04/2017 do not appear.
How could I do this?