Can anyone tell me how to caluculate a certain day of the prior month using getdate() ? The function will be hardcoded in a query that will run on either of the 1st 7 days of the month - Specifically the the 1st through the 7th day of the following month.

ie: If it runs on April 3, I need the getdate() function to retrieve March 15th,
if it runs on May 6, I need the getdate() function to retrieve April 15th.
Thanks in advance for any help.

select dateadd(dd,14,dateadd(mm,datediff(mm,'20000101',ge tdate())-1,'20000101')) '15thPrevMth'

That worked, thanks.