Datediff getting the date inbetween 2 dates and bind it to a gridview

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

Answers:

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.

Method 1

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

Method 2

TimeSpan ts = Convert.ToDateTime(dr["datereturned"]) 
            - Convert.ToDateTime(dr["dateborrowed"]);

(ts.TotalDays); // Will return the difference in Days


All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x