Calculating a monthly average and getting strange values 2024-02-29 00:00:00.
Trying this: If Day('*-1d') = 29 and Month('*-1mo') = 2 and Hour('*') >= 0 and Hour('*') < 6 then.....
It works from 01:00 but not between 00:00-01:00.
Why?
Calculating a monthly average and getting strange values 2024-02-29 00:00:00.
Trying this: If Day('*-1d') = 29 and Month('*-1mo') = 2 and Hour('*') >= 0 and Hour('*') < 6 then.....
It works from 01:00 but not between 00:00-01:00.
Why?
Hi Niklas.A ,
How are you calculating a monthly average? and when do you schedule this to run?
If you have scheduled it on the first day of each month, can you do something similar to below?
set end time as 't' and the start time as bom('y') ?
Hi Niklas.A ,
How are you calculating a monthly average? and when do you schedule this to run?
If you have scheduled it on the first day of each month, can you do something similar to below?
set end time as 't' and the start time as bom('y') ?