..

Anonymous , I can see modified on has timestamp.

 

Whatever date you join with date table should not have a time stamp.

 

Create a date like this.

Modified Date =[Modified on].Date

 

Join this date table. You should able to get the correct result.  If there is any other column, check and do same.