In my experience, it's the check out date that matters. Last year on a Visa double points promotion which ended on 31 August, I checked out of a Hilton hotel on the 1 September and did not get the double points. I queried it with HHonors and was told that the promotion was quite clear in that it ended on 31 August. Got the double points for all the earlier stays in August.
------------------
Chris