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 num | Forename | Surname | Date purchased car | date purchased house | Date purchased van | Earliest |
|---|
| 111111 | Bob | Smith | 01/01/2014 | 05/05/2014 | 01/08/2014 | 01/01/2014 |
| | | | | | |
Can this be done?
