Need SQL Query

Question

Hi I want to find out no.of days b/n tow dates but I need it something different as below. If Start Date is MM/DD/YYYY -- what ever the starting date it is I need it from starting day of the month. If End date is MM/DD/YYYY -- what ever the End date it is I need it from End day of the month. For Eg: if Start date is 03/ 10 /2005  but I need to calculate from 03/ 01 /2005 if End date is 01/ 24 /2007 but I need to calculate up to 01/ 31 /2007 Any help would be appreciated. Thanks

Ranjith Eaga · Answer

Thank you for your reply. But I need it in SQL. Please let me know if you can wirte in SQL. Thanks

Jan Montano · Answer

Hi void DateTest() { DateTime date1 = new DateTime(2007 8 10); DateTime date2 = new DateTime(2007 9 11); DateTime dateStart = new DateTime(date1.Year date1.Month 1); DateTime dateEnd = new DateTime(date2.Year date2.Month DateTime.DaysInMonth(date2.Yeardate2.Month)); TimeSpan difference = dateEnd.Subtract(dateStart); MessageBox.Show(difference.Days.ToString()); } Regards Jan