When you build a query, to report on specific data within a certain period, use the greater than and less than filters.
To include the first day and last day of this duration, increase the date by one day.
For example, if you wish to view the time frame from 01/01/17 - 30/06/17, select:
Greater than 31/12/2016
Less than 01/07/2017
Here's an example: