0

Problem with date

If I take a date field, for example invoiceDate, and want another field to calculate the due date, I'll like this:

'field due date' = invoiceDate + 30;

if value of my field invoiceDate 02.10.2018 and i add 30 days, i need my result is 01.11.2018 and not 30.10.2018 like actualy result my calculate field give me.

But the result is wrong. Why? what am I doing wrong?

Robert

6replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Robert,

    ":=" - not "="

    --

    'field due date' := invoiceDate + 30;

    --

    Leo

    Like
  • Hello Leonid,

    Sorry for my error of syntax, but in my code i use really ":=" and not "="

    I see this bug today, i think is a bug. I tested with 1.10.18 + 30 and he give me 30.10.18 and not 31.10.18 but if i add 10 or 20 is ok but greater 28 is wrong. I test many time before post a comment in the support.

    It's a little bit crazy? 

    Robert

    Like
    • Tacho
    • Tacho
    • 3 yrs ago
    • Reported - view

    I tried it with IPad-APP, Mac-OS-APP and Browser Version. All three came out right:

    Bildschirmfoto 2018-10-02 um 17.22.54

    Like
  • Thanks,

    I tried with your date and it is ok, but with my date itn's.

    Capture d’écran 2018-10-02 à 18.38.31

    But with my date :

    Capture d’écran 2018-10-02 à 18.41.14

    Like
  • Hi Robert,

    This is a known problem with summertime.
    Try this:

    'field due date' :=date(year ('invoiceDate'), month('invoiceDate'),day('invoiceDate') + 30);

    Leo

    Like
  • Thanks Leonid !!!!!!!

    Works nice with the formule date.

    Like
Like Follow
  • 3 yrs agoLast active
  • 6Replies
  • 2074Views