I need your help in writing a query to populate a date for the below scenario.
For a given quarter date, I want to get first day of the first month of the quarter and last day of the last month of the quarter.
For Example... If my quarter date is : 03-01-2013, then my startdate should be 01-01-2013 and enddate should be 03-31-2013
QuarterDate: FirstDate: LastDate:
03-01-2013 01-01-2013 03-31-2013
06-01-2013 04-01-2013 06-30-2013
Thanks in advance...!!!