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

null
    • Birger_H
    • 5 yrs ago
    • Reported - view

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

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

    Birger

    • quartz_tree
    • 5 yrs ago
    • Reported - view

    Great, thank you very much.

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 968Views