In Billing Gap Query by default based on today's date it should fetch data till previous period.

Hi Folks,

We have a query where we need to calculate gap based on today's date it should fetch date data till previous month. And also Billing gap should be cumulated month wise.
For example : If we run query for fiscal year 2017(Apr - Mar) for a period June it should fetch till from April to may and it should cumulate gap values.