AnsweredAssumed Answered

How to make this calculate value?

Question asked by restos on Apr 17, 2009
Latest reply on Apr 20, 2009 by restos

Title

How to make this calculate value?

Post

Hi there,

 

I need to make this formule in FIleMaker 9

 

Today - (other date) = X

 

X / 7 = two options:

 

1) If calculated result is an int number, this is the final value

 

2) If calculated result is not an int number then:

 

- Example: Result: 30.9

 

Then I need

 

30.9 - (its int, in this example: 30) = 0.9

 

0.9 x 7 = Final Value I need. (Value A)

 

Then I need two fields to show the calculated value

 

One field with result int, in example is 30

Other field with Value A

 

The result is type: 30 weeks and 3 days (Value A) 

 

Any Help? 

 

 

Outcomes