I need to check in my SQL stored procedure , if the input date is 3 months before now
then set it to last day of the previous month of the given date.
Ex: if the input date parameter is 02/12/2010, i need to set it to 01/31/2010
Can you please help me how o check the input date, if it is 3 months before now
and how to set it to the previous month last day of the given input date.