Bot able to pick the nearby date based on the input date

Help Activities
, ,
1

Hello All,

I have input date like “2016/05/03” and i have excel sheet it contains the following dates like below:
2021-05-06
2021-01-22
2019-06-29
2019-05-30
2017-11-04
2017-10-06
2017-09-16
2017-08-23
2016-11-24
2016-09-28

If my input date start with 2016/05/03 the bot should be able to pick nearby date like 2016-09-28 and continue till the last date 2021-05-06 in excel file…

Can anyone help me on this to pick the nearby date by bot.

2

Hi @Vamsikrishna_Talam

Use DateDiff(DateInterval.Days,ExcelDate,InputDate) …loop each data and this to find the difference and then find the least value of difference

cheers