title: Unique Start and End Effective Date Scenario
body: <p>Okay, so I have an sql query that I run on a weekly basis that now needs to be ran on a monthly basis. In the query I have a start effective date and an end effective date for the date range the report should pull. Now what I want to do is a formula for the start and end date. </p>
  
  <p>The start effective date I want to be previous month from today's date and then the last Monday of the previous month. </p>
  
  <p>The end effective date I want to be the max modified date from my product details table.</p>
  
  <p>I know what I am looking for but I am unsure how to write this in code? Thanks!!!</p>