Report for the last 3 months of duration

[Rachna S]

Hi,

We would like to iterate through data for each month for the last 3 months using a scheduled job. However, we want to be able to do this without using the 'created on last 3 months' query in the script. Is this possible ?

[Raghu Ram Y]

Didn't get you...

You want to know last three months data of a certain table/ or all tables? on a report? or just need a background script for it? or what you are expecting the output?

[Rachna S]

Hi,

Thanks for your response.

I want to retrieve data for the last 3 months but want to iterate through that data one month at a time. 

[Raghu Ram Y]

Hi @Rachna S 

Step 1 : Create a report like below screenshot.

Step 2: Go to Scheduled Reports and click on New and select you report and fill all the required fields...for reference attaching screenshot..have a look

[Raghu Ram Y]

@Rachna S any update?

If my response was helpful then please mark it as "CORRECT and HELPFUL" so that it will be helpful for future readers.