Finding beyond date as per condition?

[varunk (Varun Kumar)]

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.

[anil5 (Anil Kumar Bandam)]

Use the below condition

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

Refer the below workflow

Testing (1).xaml (15.2 KB)

[arivu96 (Arivazhagan A)]

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

[singhonkar (Onkar Singh)]

@varunk

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