Populate a date field based on three others
I'm trying to populate a date field based on 3 others.
Actual start (date) can be derived from one of the three (whichever comes first)
Civil Start
A&L Start
CX Start
Is this a dat...
Forum Discussion
You could use an IF statement in a Formula Date Field (Or Date/Time)
If([Civil Start]>[A&L Start],If([CX Start]>[Civil Start],[CX Start],[Civil Start]),[A&L Start])
------------------------------
Tammie King
------------------------------
got it to work with a (min) statement thanks though
------------------------------
Jeff Sykier
------------------------------