AnsweredAssumed Answered

FMP10 - calculate date(s)

Question asked by RaphaelVang on Aug 13, 2017
Latest reply on Aug 13, 2017 by RaphaelVang

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?

Outcomes