fixing start of day end of day problem for getting graffiti with open
status in range