PI Square

Forum Leap year gives me problem!

State Not Answered
Replies 3 replies
Subscribers 3 subscribers
Views 142 views
Users 0 members are here

Options

Related

Leap year gives me problem!

Niklas.A over 1 year ago

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?

0 MainelyInnovations over 1 year ago

I'd also recommend calculating monthly analytics on the first of the month rather than the last day of the month. It's a cleaner implementation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Community User over 1 year ago

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') ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Community User over 1 year ago

(Missing Content) and MainelyInnovations he's described the average as a Month to Date in another thread. So it gets updated as the month progresses
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel