Date Dimension gives date one day later than start date

[Grifter]

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