forum.venkateswarlu.net
      Register      Login
How to get total no of days between start date and end date in c#??

1 replies to this topic

Aisha Bobby #1
Member
96 Points
 Posted on 24 Sep 2013 12:21 PM IST

Hi,


How to get total no of days between start date and end date.


Here is the Example


StartDate:-9/24/2013 


EndDate:- 9/30/2013 


Note:-Saturday,Sunday is holiday


I want to calculate total no of days exculding saturday and sunday..In database have a table like Holidayslist...


In a textbox, the total no.of.days should display in a numeric format.


Please do the needfull.


Thanks in Advance,


Happy Coding!!!   To became perfect in coding have passions!!!!!!!


Regards,


Aisha


 

 
ASP.NET     927 views     Reply to this topic
Gaurav Dutt #2
Member
62 Points
 Replied on 24 Sep 2013 06:23 PM IST

You can use DateDiff function of SQL like;

DATEDIFF(day,'2008-09-05','2008-09-15')

 
Reply to this topic