2 Replies Latest reply on Dec 20, 2018 10:48 AM by Ayush KANSHAKAR

    Comparing 2 dates fields

    Ayush KANSHAKAR

      Hi All,

       

      I have 2 dates fields and need some calculations and logic with these fields

       

      Dates:

      1. Adjusted Service Date

      2. State Hire Date

       

      Logic:

      If Adjusted Service Date is null, use State Hire Date

      If both fields are not null, use the oldest date of the two

       

      I am not sure how to put this logic in calculation.

       

      Please help.

       

      Ayush