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



      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


      Can this be done?