How to find Nearest less than Date

[Manish_Talele]

I have to find the nearest Date from a datatable

i have to find the nearest less than date i.e image1 date

[Lahiru.Fernando]

Hi @Manish_Talele

Few steps that you can follow

1. Use a read range to read the excel onto a datatable
2. Use sort data table and sort the data in ascending order using the date column
3. Have the date you want to check in a separate variable
4. Loop through the datatable using a for each row
5. Within the loop, use a If condition to check whether the date in the data table row is less than the date you check
6. If true, assign the date to another variable
7. On the else condition of the if activity, add a break activity so that as soon as the condition doesnt match, we exit the loop.

By the time you exit, you have the nearest closest day

Hope it helps

[Manish_Talele]

Thanks that worked!