Your comments

unfortunately this doesn't work. Same things happen. days start at 11pm to 11pm next day so each date straddles both days.