Date Dimension gives date one day later than start date

I have included the mock up join for the inner query.