AnsweredAssumed Answered

Counting years/months instead of days.

Question asked by StefanSaeys on Sep 24, 2014
Latest reply on Oct 27, 2014 by philmodjunk


Counting years/months instead of days.


I’ve got a date field “start” and a number field “years”.
The calculation result is a date and the field should be (“start” + “years”) - 1 day

if start is 1/1/2010 and years is 9, then the calculation should be 31/12/2018

I’m trying to make it work for months (other field) and years, but so far it only works if it is in days.
If I start 1/1/2010 + 9 years - 1 day the calculation is 9/01/2010

How do I tell it is a month or year?

Any help welcome.