Need SQL Query

Aug 8 2007 12:40 PM

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


Answers (2)