+ Start a Discussion
pujapuja 

Filter "closedDate >: System.Today().addMonths(-6)" on Case report

I want to create a report on case where closedDate >: System.Today().addMonths(-6)

i not able to understand how i add the filter on Closed date as "cosedDate >: System.Today().addMonths(-6)"

 

Please help .It's urgent 

 

Thanks in advanced

Andy BoettcherAndy Boettcher

Are you running an actual Report or is this via APEX?

pujapuja

Yes i am running an actual report ...please help.......

Andy BoettcherAndy Boettcher

If you're having questions on the Salesforce reporting engine itself and not raw code, you're in the wrong Discussion Board man - that's probably why you weren't getting any replies here.  =)

 

What you need to do in the Report Builder is to add a Field Filter for "Closed Date", specify the operand to be "greater than" and literally type in "LAST 6 MONTHS" in the criteria field instead of a date.

 

-Andy

 

 

pujapuja

It's not working.....it give no output when i wrote "Closed Date greater than LAST 6 MONTHS"

Andy BoettcherAndy Boettcher

Are you sure you have data?  That is the correct syntax.

pujapuja

yes i am sure