0
Bug report with date function
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 ?
2 replies
-
This is the switch back from daylight saving time :-( Improve your formula like this:
–––
let myDaysToAdd := 4;
date(2019,10,24 + myDaysToAdd)
–––
Birger
-
Great, thank you very much.
Content aside
- 5 yrs agoLast active
- 2Replies
- 968Views