Skip to Content
0
Oct 31, 2016 at 08:50 PM

How to put in missing dates?

217 Views

I need to fill in some missing dates. I created a table with the dates but it doesn't seem to work. I need to be able to filter the report by staff member and once I do all the extra dates are eliminated.

This is what it shows when I filter it by date on the table i created.

Date Table: 1/1/2016

Date Table: 1/2/2016

Date Table: 1/3/2016

Date Table: 1/4/2016

Date Table: 1/5/2016

This is what I see when I filter it based on employee who had entries only the database (which is different from the table i created) for the 1st and 3rd

Date Table: 1/2/2016

Date Table: 1/4/2016

Date Table: 1/5/2016

Even though those dates are from the table i created which has all the dates. It still excludes the dates that the employee didn't have entries on. I need to also show the dates for the days they had no entries.

What am I doing wrong?

Thanks