Hi,
This is my first post here, sorry about my bad English and if i mistake something here. I would like some help in the problem below.
I have a database with 5 date columns, and i need to put each line in a crescent order, and know the types of sequence variation that i have like the tables below:
Data base Example:
| Date1 | Date2 | Date3 |
|---|
| 01/01/2015 | 02/02/2015 | 15/01/2015 |
| 02/02/2015 | 01/01/2015 | 15/01/2015 |
| 02/02/2015 | 15/01/2015 | 01/01/2015 |
Put in order:
| Column1 | Column2 | Column3 |
|---|
| 01/01/2015 | 15/01/2015 | 02/02/2015 |
| 01/01/2015 | 15/01/2015 | 02/02/2015 |
| 01/01/2015 | 15/01/2015 | 02/02/2015 |
Types of variation:
| Column1 | Column2 | Column3 |
|---|
| Date1 | Date3 | Date2 |
| Date3 | Date1 | Date2 |
| Date3 | Date2 | Date1 |
