Finding beyond date as per condition?

Help
1

Hi @All,

Capture

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.

2

Use the below condition

Convert.todatetime(row(0).ToString)<now.AddDays(1)

Refer the below workflow

Testing (1).xaml (15.2 KB)

3

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

Regards,
Arivu

4

@varunk

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

5

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