Date Calculation

[sullyman]

I have about ten fields for delivery dates in FM.

We have come up with a formula in Excel where if you enter the first date in the first cell, the remaining 9 cells will automatically fill in with correct dates etc.

E.g.

Field 2 would be Field 1 + 3 Days

Field 3 would be Field 2 + 2 Days

Field 4 would be Field 3 + 4 Days

Is this possible in FM?

Thanks,

Sully

[The Shadow]

Yes, Field1 would be a normal field of type date.

Field2 would be a calculation field, with a calculation (returning type date) of:

   Field1 + 3

Field3 is also a date type calc field:

   Field2 + 2

etc.

Edited February 9, 2008 by Guest