The date range of reports does not include the entire month or includes days from the previous month when "Last one month" is selected as the period for report generation. (4375054)

The date range of reports does not include the entire month or includes days from the previous month when "Last one month" is selected as the period for report generation.

1. Start ApexSQL Audit, add a server and database for auditing using any technology
2. Go to Start, find Services and stop the Windows time service (to be able to change the date and time on the VM without issues)
3. Change the date on the VM system to be the first day of the following month
4. Go back to ApexSQL Audit UI, navigate to Reports, select Last 1 month for the report period and then click on Generate
5. Open the report and verify that the date range does not include all days of the month or includes days from the previous month, depending on the month when the report is generated.

These were the date ranges produced during testing. The report was generated on the first day of the month and the period was set to Last 1 month:

January: 01/04 - 02/01
February: 01/30 - 03/01 (Leap Year)

February: 01/29 - 03/01

March: 03/02 - 04/01

April:  03/31 - 05/01

May: 05/02 - 06/01

June: 05/31 - 07/01

July: 07/01 - 08/01

August: 08/02 - 09/01

September: 08/31 - 10/01

October: 10/02 - 11/01

November: 10/31 - 12/01

December: 12/01 - 01/01


​Expected result: When Last 1 month is set, and the report is generated on the 1st day of the month, the report includes all the days of the previous month

• WORKAROUND

           Create separate reports for each month by manually specifying the date range and then scheduling the report generation at the desired date and time.

•      STATUS

            Waiting for a fix in the future version of ApexSQL Audit

231198