I have a table with ‘dateborrowed’ and ‘datereturned’ column. What I want to do is I want to get the value in between ‘datereturned’ and ‘dateborrowed’ and bind it to another column in another table. Also how can I do it using datediff function? I’m still learning it in the meantime. Any help would be greatly appreciated.
Thanks in advance!!
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
With C#.NET you can subtract one
DateTime from another, resulting in a
TimeSpan. For example:
TimeSpan timespan = (DateTime.Now - new DateTime(2011, 1, 1));
If you want a date in between two dates, you can then add half of this timespan to one of the dates:
TimeSpan timespan = (DateTime.Now - new DateTime(2011, 1, 1)); DateTime inBetween = DateTime.Now.AddDays(timespan.TotalDays / 2);
TimeSpan ts = Convert.ToDateTime(dr["datereturned"]) - Convert.ToDateTime(dr["dateborrowed"]); (ts.TotalDays); // Will return the difference in Days