where SubmitDate >='2021-07-01' and SubmitDate<='2021-09-30';
when I hard code the dates like this it is working as expected. I want this date to work dynamically like I should get dynamically get previous quarter data . Now Quarter 3 data ,Next Jan 1-2022 I should get 4th quarter data dynamically. Can some one help me with the formula?
Yesterday's solution didnt work as expected. I tried to use in my where condition SubmitDate BETWEEN ('$(vStartDate)' and '$(vEndDate)')and it didnt work. If i go and see my report submit date and i am seeing all dates unders submit date instead of 07/01 to 09/30 2021. I am looking for other solution which works in my scenario. Thanks!