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?
":=" - not "="
'field due date' := invoiceDate + 30;
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?
I tried it with IPad-APP, Mac-OS-APP and Browser Version. All three came out right:
I tried with your date and it is ok, but with my date itn's.
But with my date :
This is a known problem with summertime.
'field due date' :=date(year ('invoiceDate'), month('invoiceDate'),day('invoiceDate') + 30);
Thanks Leonid !!!!!!!
Works nice with the formule date.
- 4 yrs agoLast active