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)
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