Finding beyond date as per condition?

Hi @All,


Please find the above attached screenshot for reference,
I want till tomorrow’s date only { current date +1 }
If it exceeds then write in comment column as beyond date.

Use the below condition


Refer the below workflow

Testing (1).xaml (15.2 KB)

Hi @varunk,
Use read range activity get the data to datatable (dt1)

Use for each row activity
Use if condition to check
Now < Convert.ToDateTime(row(0).ToString)

If true
Use assign activity to update the value
row(1)=“beyond date”

Use write range activity to update the data into the same excel sheet



You can use DateTime.Now.AddDays(1).Date to find tomorrow date from current date.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.