Link to home
Start Free TrialLog in
Avatar of Dave KIlby
Dave KIlbyFlag for Canada

asked on

SQL Query - Days of Current Month

I am trying to run a query that pulls a report for the current month but if there is no data for a specific date it still shows the date but has zeros in the record field

For example

2020-06-01     10      $6000
2020-06-02     25      $12000
2020-06-03     0        $0
2020-06-04     5        $400

Right now when i run the query it would not show June 3rd as there is no data for that day.

Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial