Reporting Date filter : on - Last 5 months

[Ashvin1]

Hi,

I need to create report that pulled record for last 4 months & Last 5 months. is there any way to add this new value on Date filter that say like that

Created : on : Last 4 months.

As we aware out of the box : last 3 months, last 6 months and last 9 months is available.

Regards,

Ashvin

[vinothkumar]

there is a global business rule "Get Date Filter Options for Date Filters", in that add your query as well..

[Sama4]

Adding in this business rule works?   I dont think so. Its not reflecting in reports even though you add here.

[vinothkumar]

Hi Sarvamangala,

I have tried adding this condition in the business rule and   it is not working. My suggestion here is to create a script include which will include the condition that was created on last 5 months and then add it in the filter condition part of report.

I have tried and it is working in this month. In the script include part, we have to just add the condition to query last 5 months, as we don't have to check for 5 months, so I have used gs.daysAgo() in the script include part.

[lakshmiprasann3]

Can you provide the script which you had implemented to show the last 5 months data on reports?

[Zomp NOW]

In your date selection you can use relative, and choose your condition followed by however many months you want to run your report against.