3 Replies Latest reply on Aug 13, 2017 1:10 PM by RaphaelVang

    FMP10 - calculate date(s)


      I would like to calculate a date (or a number of days) - out of 2 givens;

      -starting date

      -two possible selections (14, or 7 days).



      I want in the end to have FM Pro to tell me what number in a period this date has.

      There are 6 periods. Each 14 days or 7 days long. (hence the selection).


      I want FM to tell me "you are in period 4"  if 58 days have past since the starting date. (4*14 + 2 days)  (using the 14 days selection).



      What function do I need to use?