Problem Deleting Future Data

Version 1.7.4

This seems like a simple problem and I searched high and low through this community, trying various suggestions.

This query returns a dozen or so records (note that the times are in the future):

select * from alert where time > ‘2020-01-23T00:00:00Z’ and time < ‘2020-01-25T00:00:00Z’

This command returns no errors but does not delete the data:

delete from alert where time > ‘2020-01-23T00:00:00Z’ and time < ‘2020-01-25T00:00:00Z’

I also tried with tag = ‘value’ in the where clause. Same result.

I had originally executed the delete with time > now() + 1d and most of the records got deleted correctly, however there are about 50 records across 4 series that stubbornly refuse to go away.

Any ideas?