Hello pals,
I have a file in which i have Datex and date 1 ,date2,date3 and date4 columns and my requirements is to compare 'Datex' column with other 4 date columns.
If datex = 2019-01-01
Date1=2016-01=01 Date2=2019-01=01 Date3 = 2017-09-01
Date4 = 2018-11-01
Then my requirement is to check datex column value with all other date columns and then if any of these date values is less than 30 days or greater than 30 days or falls with this range ..then the date1 column should be That valid date which falls in these category ...in the above case date 2 column falls in these category and it should be in Date1 column..
Thanks much in advance.