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.