Forum Discussion

JeffSykier's avatar
JeffSykier
Qrew Member
8 months ago

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 date formula field function? 



------------------------------
Jeff Sykier
------------------------------

2 Replies

Sort By
  • TammieKing's avatar
    TammieKing
    Qrew Cadet
    8 months ago

    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
    ------------------------------

    • JeffSykier's avatar
      JeffSykier
      Qrew Member
      8 months ago

      got it to work with a (min) statement thanks though 



      ------------------------------
      Jeff Sykier
      ------------------------------