function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Prem Singh 9Prem Singh 9 

report to retrieve records which are due to close sixth month from current month

I have a report in which I need to retreive records in a report which as due to close for sixth month from the current month. For example. if it's july I should show records which are due to close for January only. Please help me to understand how can I do that.
AnudeepAnudeep (Salesforce Developers) 
You have to build a formula field (YourDate__c +180) and add it to the report

 
Prem Singh 4Prem Singh 4
Hi Anudeep,
But if you see the formula field in report just contains number return types and not date types. How will I able to set this. And I just want data for the sixth month from now not more than sixth month data and not less.