Subtract two date columns and find differnece

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”

dt.Rows(index).Item(“Difference_Column”)= “1”

dt.Rows(index).Item(“Difference_Column”)= (col2.Subtract(col1)).ToString(“dd”)

Hope this may help you


hi @ksrinu070184 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.

Hi @Muthulakshmi_Thangamuthu

Make the little modifications as below



Nived N :robot:

Happy Automation :relaxed::relaxed:

Hi i tried it but it shows error.

Hi @Muthulakshmi_Thangamuthu

Try this


Nived N
Happy Automation


But no luck its throwing “Assign: Exception has been thrown by the target of an invocation”. run time error

hi @Muthulakshmi_Thangamuthu

where are u getting the data ?

means the datetime?

Yes its date time.

Test.xlsx (7.9 KB)
DatediffSum.xaml (9.7 KB)

this is the sample flow

Hi @Muthulakshmi_Thangamuthu

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)


Nived N

Happy Automation

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