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.
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
Convert.todatetime(row(0).ToString)<now.AddDays(1)
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
Regards,
Arivu
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.