AnsweredAssumed Answered

Auto-fill fields with calculation

Question asked by Terri on Jan 26, 2011
Latest reply on Apr 1, 2011 by Terri

Title

Auto-fill fields with calculation

Post

Hi,

I am trying to find a way for FM to auto fill dates based on the date I put in one "master" field. Hopefully the explanation below is enough to explain.

Master Field - Jan 1

Field 1 = 2 days later than master field or Monday January 3rd

Field 2 = 4 days later than master field or Wednesday January 5th

Field 3 = 7 days later than master field or Saturday January 8th **BUT** if this day lands on a Saturday it needs to subtract a day and land on Friday January 7th. (in other words, field 1, 2, 3, etc. can only equal a Mon-Fri business day).

Field 4 = 8 days later than master field or Sunday January 9th **BUT** if this day lands on a Sunday it needs to add a day and land on Monday January 10th.

Any ideas? Thanks!

Outcomes