2 Replies Latest reply: Aug 7, 2014 11:49 AM by Manish Kachhia RSS

    Earliest date

    Paul Wonford

      Hi guys,

       

      I have a file with customer information

       

      NI number

      Forename

      Surname

      Date purchased car

      Date purchased house

      Date purchased van

       

      I'd like to be able to pull out the earliest date between date purchased car, date purchased house and date purchased van. For example see below

       

      NI numForenameSurnameDate purchased cardate purchased houseDate purchased vanEarliest
      111111BobSmith01/01/201405/05/201401/08/201401/01/2014

       

      Can this be done?