Populate a date field based on three others

Question

I'm trying to populate a date field based on 3 others.&nbsp;&nbsp;
Actual start (date) can be derived from one of the three (whichever comes first)&nbsp;

Civil Start&nbsp;
A&amp;L Start&nbsp;
CX Start

Is this a date formula field function?&nbsp;
------------------------------Jeff Sykier------------------------------

tammieking · Answer

You could use an IF statement in a Formula Date Field (Or Date/Time)If([Civil Start]&gt;[A&amp;L Start],If([CX Start]&gt;[Civil Start],[CX Start],[Civil Start]),[A&amp;L Start])
------------------------------Tammie King------------------------------

jeffsykier · Answer

got it to work with a (min) statement thanks though&nbsp;
------------------------------Jeff Sykier------------------------------

Forum Discussion

Populate a date field based on three others