Monthly time shift

Hi, Im using relative time now/M and this gives me “This month so far” starting from 1st day. However, I want that it starts from day 8 because that is when my electric bill billing cycle starts. Can I somehow shift it forward?

You can, set from to something like now-7d/M+7d to get your billing period. The logic here is: Start from the current time, go back 7 days so you’re sure you’re in the starting month of the period and round down to the beginning of the month. Add 7 to go to the 8th day of the month (it’s -1 since it’s an offset from the first day).


Thank you, that worked like a charm!

1 Like