Hi,
i want to find difference bw two dates from two columns which From Date and To Date.
In for each row i tried ,
col1 = Convert.ToDateTime(row(“From Date”).ToString)
col2 = Convert.ToDateTime(row(“To Date”).ToString)
dt.Rows(index).Item(“Difference_Column”)= (col2.Subtract(col1)).ToString(“dd”)
the above condition works well, but if “From date and To date” are same it returns “0” but the expected output should be “1”. How to achieve this
As you are subtracting the date so if it is same date then it will result to zero.
To make it 1 make a if condition that (col2.Subtract(col1)).ToString = “0”
Then
dt.Rows(index).Item(“Difference_Column”)= “1”
Else
dt.Rows(index).Item(“Difference_Column”)= (col2.Subtract(col1)).ToString(“dd”)
Hope this may help you
Thanks
hi @Srini84 thanks for the suggestion.
Here i would like to add (+1) day for all the result not only for “0”.
I tried using Adddays(+1) but nothing works.
Make the little modifications as below
(col2.Subtract(col1)).AddDays(1).ToString(“dd”)
Regards
Nived N 
Happy Automation 
Thanks @NIVED_NAMBIAR
But no luck its throwing “Assign: Exception has been thrown by the target of an invocation”. run time error
Is there any column name Status in the excel file?
I think that was issue
i added a status in the excel and run your workflow
it work fine
Test.xlsx (8.6 KB)
DatediffSum.xaml (9.7 KB)
Regards,
Nived N
Happy Automation
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
