Hi All,
I want to create a report of opportunities with Estimated close date in next 2 months AFTER current month.
Current filters don't have this option, can anybody please suggest a way to do this?
*This post is locked for comments
Hi All,
I want to create a report of opportunities with Estimated close date in next 2 months AFTER current month.
Current filters don't have this option, can anybody please suggest a way to do this?
*This post is locked for comments
Hi Bharat,
Brilliant , thanks!
Hi,
There is a workaround for this if your not using Fiscal Years.
You have to change your Fiscal Year settings to be Monthly:
Then within Advanced Find do:
Regards
Bharat
Hi Temmy, thanks for your prompt response but sadly that doesn't solve my problem.
I want an advanced view for the dashboard and not report.
The next X months would have been ideal but it pulls current month too which we dont want.
Hi,
For advance find, we have Next X Hours, Days, and Month. But if you want static parameters like 2 months, I believe we don't have this.
If you want to create a report using ssrs, you can add custom parameters and construct value from there. So your user will choose the parameter based on your created one.
docs.microsoft.com/.../report-parameters-report-builder-and-report-designer
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
Community Member
52
Victor Onyebuchi
6