1 2 Previous Next 16 Replies Latest reply on Oct 27, 2014 9:00 AM by philmodjunk

    Counting years/months instead of days.

    StefanSaeys

      Title

      Counting years/months instead of days.

      Post

      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.

        1 2 Previous Next