from the given query results which include 3 date fields, 1) Intake date 2) Rec Date 3) Closed Date
I have to generate a report like, from date range 8/28/05 - now(whatever date the report is generated), the format of the report to be.
Toatal number of records for each date between begin to end date as in below, no matter even if the count is zero as in the example below for 8/29/05
8/29/05 0 0 0
Starting from 8/28/05 to now()
#Intakes #Rec #Closed
8/28/05 0 3 5
8/29/05 0 0 0
8/30/95 3 2 1
and so on until the final date.
How to achieve this
I have to generate a report like, from date range 8/28/05 - now(whatever date the report is generated), the format of the report to be.
Toatal number of records for each date between begin to end date as in below, no matter even if the count is zero as in the example below for 8/29/05
8/29/05 0 0 0
Starting from 8/28/05 to now()
#Intakes #Rec #Closed
8/28/05 0 3 5
8/29/05 0 0 0
8/30/95 3 2 1
and so on until the final date.
How to achieve this
