I have a SP, where there are two parameters fromdate and todate to get monthly sale value. Now , i have a query, that how can i display the previous month sales for the date set for fromdate and todate parameter. Request you to please help me on this.
E.g: fromdate='2022-07-01',todate='2022-07-30' Prevoius month sales required 2022-06-01 ,2022-06-30