Hi community !
I need your help,
In my script, i'd like to create a test on different type of date, and put a warning when the date is on Christmas or on the first of the year
I have five differents type of dates :
DATA :
ID | Step0 | Step1 | Step2 | Step5 | Step9 |
---|
1 | 12/12/2017 | 10/12/2017 | 10/12/2017 | 18/12/2017 | 18/12/2017 |
2 | 01/01/2017 | 10/12/2017 | 13/12/2017 | 18/12/2017 | 18/12/2017 |
3 | 12/12/2017 | 10/12/2017 | 10/12/2017 | 25/12/2017 | 25/12/2017 |
4 | 10/12/2017 | 10/12/2017 | 18/12/2017 | 18/12/2017 | 18/12/2017 |
... | ..... | | | | |
n | 12/12/2017 | 10/12/2017 | 10/11/2017 | 18/12/2017 | 18/12/2017 |
What I want :
DATA :
ID | Step0 | Step1 | Step2 | Step5 | Step9 | Test |
---|
1 | 12/12/2017 | 10/12/2017 | 10/12/2017 | 18/12/2017 | 18/12/2017 | ok |
2 | 01/01/2017 | 10/12/2017 | 13/12/2017 | 18/12/2017 | 18/12/2017 | Warning Step0 it's 01/01 |
3 | 12/12/2017 | 10/12/2017 | 10/12/2017 | 25/12/2017 | 25/12/2017 | Warning Step5 it's 25/12 , Warning Step9 it's 01/01 |
4 | 10/12/2017 | 10/12/2017 | 18/12/2017 | 18/12/2017 | 18/12/2017 | ok |
... | ..... | | | | | |
n | 12/12/2017 | 10/12/2017 | 10/11/2017 | 18/12/2017 | 18/12/2017
| ok |
Do you have an idea ?
Thank you !
Victor