I have a line:

```
sum(purchases) over(partition by category order by value_day range between interval '1' month preceding and current row) 

```

If `value_day = Aug 21`, it returns sum from and included July 21 till and included Aug 21, but I need from and included July 22 till and included Aug 21.

How can I do that?