Bug report with date function
J

Hi,

I noticed apparently a bug or a behaviour that I do not understand with the date function 

date(2019,10,24)+1 : result = 25 10 2019 -> ok 

date(2019,10,24)+2 : result = 26 10 2019 -> ok 

date(2019,10,24)+3 : result = 27 10 2019 -> ok 

date(2019,10,24)+4 : result = 27 10 2019 -> Oooops it should return 28 10 2019

date(2019,10,24)+5 : result = 28 10 2019 -> here again we lose a day

It that it works with other date but apparently there is a problem in the case above

Any idea what is happening here ?

 

 

 

 

Ninox Profile

This is the switch back from daylight saving time :-( Improve your formula like this:

–––
let myDaysToAdd := 4;
date(2019,10,24 + myDaysToAdd)
–––

Birger

J

Great, thank you very much.

Reply