Hi,
I've checked on my end but I'm not able to reproduce the problem.
If I set a start date in the future, the discount is ignored as it should and if I set an end date in the date, the discount is also ignored as it should, and if the start date is in the past and the end date in the future, the discount is used.
So I'm thinking you might just be experiencing an issue with the timezone settings of your website/server since your testing sale range is only 1 day and you only have a few hours of difference between the server date and the sale range bounds.
To confirm that, try with several days in the past/future for the dates and you should see that it works properly.